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.

--
HTH

Bob Phillips

"mkobulni" wrote in message
...
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?