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 |
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 |
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 |
All times are GMT +1. The time now is 03:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com