shift premiums in formula on time sheet

[Guest]

Hi hope you can help me. I am just learning excel. I am trying to make a time sheet and I have everything figured out except for shift premiums. If I work between 00:00 - 08:00 shift premium is $.50/hr If I work between 16:00 - 00:00 premium is $.35/hr. My reg working hours are from 8:00-16:00, but occasionally I work before 08:00 and stay longer than 16:00. How can I add in the shift premiums to the formulas? Our pay is calculated every 6 minutes...eg: if i worked until 17:15 ...I only get paid until 17:12. Please help. I have been looking on the net for some tips but this is a little confusing for me.
Thanks in advance, Terr

 

[Guest]

I forgot to mention my overtime rate is 1.5 x reg rate after 8 hours worked
Thanks again

 

[David McRitchie]

Hi Terri,
See if the following helps for time outside core hours:
http://www.mvps.org/dmcritchie/excel/datetime.htm#core

For the 6 minutes part try subtracting the the remainder which
is calculated
0:15 0:12 =A1-MOD(A1,1/240)
0:23 0:18 =A2-MOD(A2,1/240)
0:24 0:24 =A3-MOD(A3,1/240)

Hi hope you can help me. I am just learning excel. I am trying to make a time sheet and I have everything figured out except for

shift premiums. If I work between 00:00 - 08:00 shift premium is $.50/hr If I work between 16:00 - 00:00 premium is $.35/hr. My
reg working hours are from 8:00-16:00, but occasionally I work before 08:00 and stay longer than 16:00. How can I add in the shift
premiums to the formulas? Our pay is calculated every 6 minutes...eg: if i worked until 17:15 ...I only get paid until 17:12.
Please help. I have been looking on the net for some tips but this is a little confusing for me.