calulating a certain weekday hours within a 24 hour roster
 

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

calulating a certain weekday hours within a 24 hour roster
 

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"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"F. Learning" wrote:

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

calulating a certain weekday hours within a 24 hour roster
 

Many Thanks for your reply.

The Sunday/ Monday should have read 4 hrs premium.



"Shane Devenshire" wrote:

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"

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"F. Learning" wrote:

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