PPRuNe Forums - View Single Post - Excel Formula
Thread: Excel Formula
View Single Post
Old 15th August 2001 | 23:04
  #20 (permalink)  
Gash Handlin
 
Joined: Sep 2000
Posts: 161
Likes: 0
From: err not tellin anymore
Post

Bally Heck,

Read my post on the first page,

You don't have to use ANY formula to display times greater than 24 hours, simply change the format of the cell that displays the result from HH:MM to [H]:MM.

This does not work with microsoft works however, as you can't seem to apply customised formats and have to use one of the five or so they provide, gits

(I appreciate this doesn't help with the original problem as you still have to enter the time, seperated by : )

GH
Gash Handlin is offline