calculating hourly rate using [h]:mm:ss format

  • Thread starter Thread starter Tat
  • Start date Start date
T

Tat

I am trying to calculate the hourly rate by dividing gross
pay by the total number of hours worked.
In order to add time worked, I custom formatted it to
[h]:mm:ss so that exact time worked could be added
together. When I try to divide the gross by this
calculated time it comes up with the incorrect answer. It
seems that I need to convert the time somehow to decimals
but I haven't found a way that works.
eg:gross = 4235.75
actual time worked = 42:30:30
 
Back
Top