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

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

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