calulating a certain weekday hours within a 24 hour roster

  • Thread starter Thread starter F. Learning
  • Start date Start date
F

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
 
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"
 
Back
Top