calulating a certain weekday hours within a 24 hour roster

[F. Learning]

I am new to excel formulae bar the basis and have prepared a spread sheet for
input to calculate shift hours worked. I now wish to identify Sunday hours as
these are paid at a premium rate.

For example a shift 8pm to 8am on sat/sun gives 4 hours premium
a Sunday shift 8am to 8pm gives 12 hr premium
a Sunday/Monday shift 8pm to 8am gives a 8 hour premium
The input fields are only time in and time out. Rostered hours are
calculated as
Follows:
=((H8-G8)+(H8<G8))*24. where H8 is the time finished(Sun or
Mon) and G8 is the start time.(Sun)
Is there anyway I can identify Sunday hours worked.

Many Thanks

 

[Shane Devenshire]

Hi,

First there doesn't seem to be any way to identify the day of the week if
all you input are the start and end times. Second, I don't follow the logic

"a Sunday/Monday shift 8pm to 8am gives a 8 hour premium"

 

[F. Learning]

Many Thanks for your reply.

The Sunday/ Monday should have read 4 hrs premium.