#1   Report Post  
mkobulni
 
Posts: n/a
Default 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?

  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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?



  #3   Report Post  
mkobulni
 
Posts: n/a
Default

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?




  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

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?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting from time format to decimal and figuring the difference Steve Williams Excel Discussion (Misc queries) 1 July 30th 05 11:10 PM
Adding time damezumari Excel Discussion (Misc queries) 2 June 20th 05 09:35 PM
convert number to time format? JLHORMAN Excel Discussion (Misc queries) 1 May 26th 05 07:38 PM
subtraction with time format cells Stefano Excel Worksheet Functions 2 March 17th 05 04:06 PM
adding military time format am6160 Excel Discussion (Misc queries) 2 December 28th 04 09:41 PM


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"