calculating double time on a workorder
 

i am trying to calculate how many reg hours, overtime hours and double time
hours on a workorder in which i just enter the date, start time and end time

calculating double time on a workorder
 

There are a lot of variables that could go into this that you may or
may not need.

How do you currently calculate these? If you relay that information
then the formulas can be designed to that way.

Are your workoders processed 24 hours a day? Do you times span
multiple days? If yes, then that's a very important pieces of
information.

Are multiple workers working on a specific workorder?

Any information that you can add to this is always welcome. A clear,
concise description of the problem including data examples is the
easiest way to get your problem solved.

Cheers,
Jason Lepack

E-QUIP wrote:
i am trying to calculate how many reg hours, overtime hours and double time
hours on a workorder in which i just enter the date, start time and end time

calculating double time on a workorder
 

For the reg time (i'll assume 8 hours) and assume the start and end
times are in B2/C2:

D2: =MIN(C2-B2,8/24)

For overtime (i'll assume between 8 and 12 hours):

E2: =MIN(4/24,MAX(C2-B2-D2,0))
E2: =MIN(4/24,MAX(C2-B2-8/24,0))

For double time (i'll assume anything over 12 hours):

F2: =MAX(0,C2-B2-D2-E2)
F2: =MAX(0,C2-B2-12/24)

For the second two, the first version references the other
calculations, the second just references the original two times.

Hope it makes sense.

Scott

E-QUIP wrote:
i am trying to calculate how many reg hours, overtime hours and double time
hours on a workorder in which i just enter the date, start time and end time

calculating double time on a workorder
 

our regular hours are m-f 7:00am to 3:30 pm anything before or after those
hours are overtime all day saturday is overtime and all day sunday is double
time. i want to enter start time in one cell end time in another cell and
have a cell for lunch if one is taken i will enter how much is taken whether
it be .50 hrs or whatever. your help is greatly appreciated.

"Jason Lepack" wrote:

There are a lot of variables that could go into this that you may or
may not need.

How do you currently calculate these? If you relay that information
then the formulas can be designed to that way.

Are your workoders processed 24 hours a day? Do you times span
multiple days? If yes, then that's a very important pieces of
information.

Are multiple workers working on a specific workorder?

Any information that you can add to this is always welcome. A clear,
concise description of the problem including data examples is the
easiest way to get your problem solved.

Cheers,
Jason Lepack

E-QUIP wrote:
i am trying to calculate how many reg hours, overtime hours and double time
hours on a workorder in which i just enter the date, start time and end time

calculating double time on a workorder
 

could i send you a copy of my workorder? to show you exactly what i am trying
to do? if so how do i attach it? i am quite new to this discussion group.

"Jason Lepack" wrote:

There are a lot of variables that could go into this that you may or
may not need.

How do you currently calculate these? If you relay that information
then the formulas can be designed to that way.

Are your workoders processed 24 hours a day? Do you times span
multiple days? If yes, then that's a very important pieces of
information.

Are multiple workers working on a specific workorder?

Any information that you can add to this is always welcome. A clear,
concise description of the problem including data examples is the
easiest way to get your problem solved.

Cheers,
Jason Lepack

E-QUIP wrote:
i am trying to calculate how many reg hours, overtime hours and double time
hours on a workorder in which i just enter the date, start time and end time