Time
if you use the format [h]:mm:ss for a cell, you can enter numbers like 3:20 which will be 3 hours 20 minutes, and also numbers up 9999:20 which will be 9999hours and 20minutes.
Seems only up to 4 digits of hours can be input in that format, although if you want to display more digits of hours then format the cell as [hhhhhhhh]:mm:ss with as many h as required.
Remember you can also add dates and times quite happily in excel, for instance
a cell formatted as [h]:mm:mm containing 24:00 and a cell formatted as dd/mm/yyy containing 20/07/2007 and summed will give the result 21/07/2007 if the format is dd/mm/yyy
all dates start from 1900, and any date without a time assumes 00:00:00
Don't need any of the complicated stuff above at all.
(I am using excel 2003 by the way)
For another little tip, try this.
cell a1 format [h]:mm:ss
cell a2 format as number with 2 decimal places, content =a1
cell a3 format as 0.00"hours", content =a2*24
then type 24:00 into cell a1, a2 will display 1.00, a3 will display 24.00hours
type 12:00 into cell a1, a2 will display .5, a3 12.00hours
type 12.30 into a1, a2 will display 0.52, a3 12.50hours
why bother with anything more complicated?
let me know if you don't understand or need more help.
Last edited by stickyb; 12th September 2007 at 11:24.
Reason: added a bit more