Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
Adding time | Excel Discussion (Misc queries) | |||
convert number to time format? | Excel Discussion (Misc queries) | |||
subtraction with time format cells | Excel Worksheet Functions | |||
adding military time format | Excel Discussion (Misc queries) |