A
ab3d4u
I have a feeling this was asked many times before. What I want is a
simple formula to calculate hours worked. From the time cards an "IN"
and "OUT" time is read. All I want is to put in column A "time in" and
in column B "time out" and get the "total hours worked" in column C.
- we pay by rounding to the nearest 15 minutes
- break time is not shown in the time card. No need to worry about
it.
- OT is only after 8 hours or 40 hours a week. Vary rare
- payroll is processed once a month
Thanks for your help
simple formula to calculate hours worked. From the time cards an "IN"
and "OUT" time is read. All I want is to put in column A "time in" and
in column B "time out" and get the "total hours worked" in column C.
- we pay by rounding to the nearest 15 minutes
- break time is not shown in the time card. No need to worry about
it.
- OT is only after 8 hours or 40 hours a week. Vary rare
- payroll is processed once a month
Thanks for your help