LOUISBUHAGIAR54
Registered User.
- Local time
- Yesterday, 19:57
- Joined
- Mar 14, 2010
- Messages
- 157
My problem has been met with others before but despite adequate searches I have not managed to solve it.
I am creating query that calculates time interval so that this is used to calculate pay. Employees clock in at [time_in] and clock out at [time_out]. Sometimes time_out is on the next day of time_in.
So if is substract time_out - time_in I will get a negative number.
I am therefore using the following formula to extract the time interval;
Interval: Format([time_out]-[time_in],"Short Time")
this gives out a result such as 3:30 when in fact I would need 3.5 to calculate pay by multiplying with rate.
How do I convert 3:30 to 3.5. From the searches I get that I need to multiple 3:30 by 24. But when in put done in the query
Interval: Format([time_out]-[time_in],"Short Time")*24
it will not work out. I get an error.
Can anyone please help with my problem ?
Louis Buhagiar
I am creating query that calculates time interval so that this is used to calculate pay. Employees clock in at [time_in] and clock out at [time_out]. Sometimes time_out is on the next day of time_in.
So if is substract time_out - time_in I will get a negative number.
I am therefore using the following formula to extract the time interval;
Interval: Format([time_out]-[time_in],"Short Time")
this gives out a result such as 3:30 when in fact I would need 3.5 to calculate pay by multiplying with rate.
How do I convert 3:30 to 3.5. From the searches I get that I need to multiple 3:30 by 24. But when in put done in the query
Interval: Format([time_out]-[time_in],"Short Time")*24
it will not work out. I get an error.
Can anyone please help with my problem ?
Louis Buhagiar
Last edited: