Format Time
 

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?

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?

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

"Bob Phillips" wrote:

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?

Sorry, I used

A22: =A21+Time(12,0,0)

--
HTH

Bob Phillips

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

"Bob Phillips" wrote:

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?