Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 120
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 87
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Time Karen Excel Worksheet Functions 2 December 7th 06 10:24 PM
Calculating time increments from dates during working hours S Davis Excel Worksheet Functions 0 October 24th 06 03:32 PM
calculating time mats Excel Worksheet Functions 9 August 24th 06 02:34 PM
time sheet drop down lists Steve Excel Discussion (Misc queries) 12 March 18th 06 11:30 PM
Calculating tvl time in Excel 2000 Rev.9.2720 Brandi Excel Worksheet Functions 5 January 27th 05 10:15 PM


All times are GMT +1. The time now is 06:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"