Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Premium Time
Example 1: Sat Sat/Sun Start Finish A1 B1 8:00 20:00 Start Saturday morning end Saturday evening. A2 B2 Roster 12.00 Example : Start Finish A1 B1 20:00 08:00 Start Saturday evening end Sunday Morning A2 B2 Roster 12.00 I am using the following formula to caluclate the hours attibutable to Sunday. Can some one help as the result is not correct where the shift ends on Saturday =if(a2="roster",24*(if B1<A1,B1,B1-A1)),0) Example 1 above result =12 hours incorrect as all Saturday Hours Example 2 above result =8 hours which is Correct Can some-one put me right please F. Learning |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Premium Time
Hi,
take a look at CPearson web has excellent examples http://www.cpearson.com/excel/overtime.htm if this helps please click yes, thanks "F. Learning" wrote: Example 1: Sat Sat/Sun Start Finish A1 B1 8:00 20:00 Start Saturday morning end Saturday evening. A2 B2 Roster 12.00 Example : Start Finish A1 B1 20:00 08:00 Start Saturday evening end Sunday Morning A2 B2 Roster 12.00 I am using the following formula to caluclate the hours attibutable to Sunday. Can some one help as the result is not correct where the shift ends on Saturday =if(a2="roster",24*(if B1<A1,B1,B1-A1)),0) Example 1 above result =12 hours incorrect as all Saturday Hours Example 2 above result =8 hours which is Correct Can some-one put me right please F. Learning |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate Premium Time
Checked out the site but nothing there to help f "Eduardo" wrote: Hi, take a look at CPearson web has excellent examples http://www.cpearson.com/excel/overtime.htm if this helps please click yes, thanks "F. Learning" wrote: Example 1: Sat Sat/Sun Start Finish A1 B1 8:00 20:00 Start Saturday morning end Saturday evening. A2 B2 Roster 12.00 Example : Start Finish A1 B1 20:00 08:00 Start Saturday evening end Sunday Morning A2 B2 Roster 12.00 I am using the following formula to caluclate the hours attibutable to Sunday. Can some one help as the result is not correct where the shift ends on Saturday =if(a2="roster",24*(if B1<A1,B1,B1-A1)),0) Example 1 above result =12 hours incorrect as all Saturday Hours Example 2 above result =8 hours which is Correct Can some-one put me right please F. Learning |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 calculate time between 2 date/time columns | Excel Discussion (Misc queries) | |||
Calculate the duration between the end time and start time of anot | Excel Worksheet Functions | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) |