How to calculate Premium Time

[F. Learning]

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

 

[Eduardo]

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]

Checked out the site but nothing there to help


f