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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating payroll cost 1
keep old cell value and new cell value 2
convert [h]:mm:ss to real number that I can use as a multiplier 3
how to multiply h:mm value by an hourly $ rate 2
multiply time with hourly rate 2
Divide a cell by 2 and then add that together 8
Calculating hours worked with an hourly rate 1
Excel Convert Datetime Stamp to HH and MM Worked 7

Top