Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
calculating hourly rate using [h]:mm:ss format
0 views
Skip to first unread message
Tat
Oct 6, 2003, 1:30:15 PM10/6/03
to
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
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
Peo Sjoblom
Oct 6, 2003, 1:45:21 PM10/6/03
to
Try
gross_pay/(hours_worked*24)
format as general or currency
--
Regards,
Peo Sjoblom
"Tat" <Tatjan...@rehab-express.com> wrote in message
news:0d6801c38c2f$80f49510$a001...@phx.gbl...
0 new messages