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




--
ab3d4u

Get this formula to have total time rounded to nearest 0:15
=MROUND(B1-A1,1/24/4)
To best would probably be to get yourself a decent timesheet. Many folks
here have design one or another

"ab3d4u" wrote:


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




--
ab3d4u

You know, there is a popular regular-overtime-rate calculation method making
rounds. Here it is:
C1 contains total hours worked
D1 contains overtime limit. Say 40:00
Another cell contains this:
=MIN(C1,D1)*Rate*24+(C1D1)*OTrate*24*(C1-D1)
Where "rate" could be substituted for a range containd a value, or a defined
name
Where "OTrate" could be substituted for a range containd a value, or a
defined name


"ab3d4u" wrote:


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




--
ab3d4u