cell properties. hours?

B

bobbych

hi

i need to create a setup where i input the running hours and mins for
component. This input will add to a diff cell which contains tota
running hours and mins.

eg hours used today=3:40 need to add this to total hours

total hours =11350:20

cell properties does not have a setup for hhhhh:mm only hh:mm
is it possible?
cheer
 
F

filky

You can use [h]:mm as a custom format but this will still fall foul of
the limit in excel. The largest amount of time that can be entered is
9999:59:59
 
Top