How to calculate Premium Time


F

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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top