G
Guest
A previous post provided the below great solution to calculate the difference
between 2 time values.
Hours: Format([TimeIn]-1-[TimeOut],"Short Time")
TimeIn TimeOut Hours
8:00:00 AM 4:30:00 PM = 08:30
I now need to multiply the above calculated elapsed time by the hourly rate
of an employee to get their pay. (ie: 10.00 X 08:30 ). However due to the
formula being currency times time data type, it of course doesn't work. I've
tried all kinds of formatting but am stumped to make it work, how can or
should this be done?
thank you!
between 2 time values.
Hours: Format([TimeIn]-1-[TimeOut],"Short Time")
TimeIn TimeOut Hours
8:00:00 AM 4:30:00 PM = 08:30
I now need to multiply the above calculated elapsed time by the hourly rate
of an employee to get their pay. (ie: 10.00 X 08:30 ). However due to the
formula being currency times time data type, it of course doesn't work. I've
tried all kinds of formatting but am stumped to make it work, how can or
should this be done?
thank you!