| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
