Thread: Format Time
View Single Post
  #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?