Format Time

M

mkobulni

For payroll we collect the Regular base pay from each department from a
report that gives us HH:MM:SS. That number can reach into the ten thousands
of hours. We transfer the hours from a report to Excel. Unfortunately,Excel
can only accept 4 digits in the hours section(ex - 9999:00:00) So, Excel can
go up to 9,999 hours. Is there a way of increasing this number to handle up
to 100,000 hours?
 
B

Bob Phillips

I don't know how you are entering the data, but interestingly I found that
you can directly enter more than 9999 hours in Excel, but you can add and
get more than 9999.

For instance, input 9999 in A21. In A22 use
and it shows 10011:00

You may be able to utilise that.
 
M

mkobulni

For instance, input 9999 in A21. In A22 use ?????(what did you intend to type
here, Bob)
and it shows 10011:00
 
Top