B
Bret
In a previous post this wonderful solution to calcuating the difference
between to Time entries for payroll calculation.
TimeIn TimeOut
8:00:00 AM 4:30:00 PM
Hours: Format([TimeIn]-1-[TimeOut],"Short Time") = 08:30
I now must multiply an employees hourly wage by the calculated time above.
example: $10.00 X 08:30
because its currency divided by a time datatype of course it doesnt
multiply, I've tried all types of Format functions to figure this out but am
stumped. Please how can I convert the time value to a corresponding
number/decimal value to calculate an employees pay.
thanks in advance.
between to Time entries for payroll calculation.
TimeIn TimeOut
8:00:00 AM 4:30:00 PM
Hours: Format([TimeIn]-1-[TimeOut],"Short Time") = 08:30
I now must multiply an employees hourly wage by the calculated time above.
example: $10.00 X 08:30
because its currency divided by a time datatype of course it doesnt
multiply, I've tried all types of Format functions to figure this out but am
stumped. Please how can I convert the time value to a corresponding
number/decimal value to calculate an employees pay.
thanks in advance.