Data Input - Times with hours over 10000

  • Thread starter Thread starter Lars Andersen
  • Start date Start date
L

Lars Andersen

I have a time sheet that adds hours/minutes , but trying to input into a
cell using [h]:mm format anything over 9999:59 (ie 10000 or greater) is not
allowed.

What I have been doing is to break the greater than 10000 hours into 2
figures each < 10000 and then summing them, which works OK.

What am I missing with this, or is it a genuine limitation?
 
Divide by 24, i.e.
you want 25000 hours

=25000/24

format as [h]:mm

if you want 25000:25

=25000/24+TIME(,25,)

note the 2 commas in the time formula
 
Back
Top