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