Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Time | Excel Worksheet Functions | |||
Calculating time increments from dates during working hours | Excel Worksheet Functions | |||
calculating time | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions |