Calculation of time

[ohi]

I found this page, which lead me to this code:

Format([StartTime] -1 -[EndTime], "Short Time")

which works fine for part of my issue. My other issue is that I need to subtract 8 hours from that time for OT hours, and I've failed on many levels trying to achieve that. Also my OT hours would be in a different format all together.

I need them formatted for an hour and a half 1.5. They will never be anything but an hour/half an hour increments.

I've done many google searches including the datediff() function and can't find any solutions to this issue.

I'm not even sure if this is possible via access. Any help in the right direction would be great.

 

[PNGBill]

Maybe you don't need to change the Hours but just the final Integer Value or even the Hourly Rate.

Most payroll systems record the hours worked as an accurate value of single hours and have Normal Pay and Overtime Pay being 1.5 x normal pay.

If you can calculate the overtime hours then once you have the value, multiply it by 1.5 if you want to store the result