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