View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
E-QUIP E-QUIP is offline
external usenet poster
 
Posts: 12
Default 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