Home |
Search |
Today's Posts |
#1
|
|||
|
|||
time calculations
I have a spreadsheet that 'looks like this' (http://img43.imageshack.us/img43/7485/pay1cl.jpg) to be used for calculating the hours I work. The "normal", "evening" and "premium" hours refer to 0600-1800, 1800-0000, 0000-0600, respectively. The formula for F6 would be: =IF(B6<E6,MIN(E6,1800)-MAX(B6,600),1800-B6) (not taking into account the break) How would I change this formula to deal with the breaks and hence what would be the correct formula for the evening and premium hours. Sorry, I'm having a real hard time getting my head round this. -- craigj ------------------------------------------------------------------------ craigj's Profile: http://www.excelforum.com/member.php...o&userid=27355 View this thread: http://www.excelforum.com/showthread...hreadid=470552 |
#2
|
|||
|
|||
Aren't you missing the formulae for overtime and premium hours?
-- HTH Bob Phillips "craigj" wrote in message ... I have a spreadsheet that 'looks like this' (http://img43.imageshack.us/img43/7485/pay1cl.jpg) to be used for calculating the hours I work. The "normal", "evening" and "premium" hours refer to 0600-1800, 1800-0000, 0000-0600, respectively. The formula for F6 would be: =IF(B6<E6,MIN(E6,1800)-MAX(B6,600),1800-B6) (not taking into account the break) How would I change this formula to deal with the breaks and hence what would be the correct formula for the evening and premium hours. Sorry, I'm having a real hard time getting my head round this. -- craigj ------------------------------------------------------------------------ craigj's Profile: http://www.excelforum.com/member.php...o&userid=27355 View this thread: http://www.excelforum.com/showthread...hreadid=470552 |
#3
|
|||
|
|||
Bob Phillips Wrote: Aren't you missing the formulae for overtime and premium Yes, I am. I don't know what the formula is. The formulae you provided previously don't work, other than the one for regular hours. -- craigj ------------------------------------------------------------------------ craigj's Profile: http://www.excelforum.com/member.php...o&userid=27355 View this thread: http://www.excelforum.com/showthread...hreadid=470552 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet calculations | Excel Worksheet Functions | |||
Time Calculations | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
Time calculations & text conversions | Excel Discussion (Misc queries) | |||
Time Sheet calculations | Excel Worksheet Functions |