Computing Shift differentials

Jay2000

New Member
Joined
Dec 5, 2005
Messages
6
If before 6:00AM or after 6:00PM then they get differential pay

A1 Time In 5:30 AM
B1 Time Out 1:30 PM
D1 Should have .5 Shift Differential


A2 Time in 5:30 PM
B2 Time out 1:30 AM
D2 Should have 7.5 Shift Differential

TEXT(IF(B16 <> "",IF(B16<G$3,G$3+B16,0),0),"hh:mm")*24

The first if statement is cosmetic, the second gives me 11.5 for the first example

I have not yet figured out how to combine the AM and PM together yet into on function.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Jay2000

New Member
Joined
Dec 5, 2005
Messages
6
I figured out why I was getting 11.5 instead of .5. I was adding and not subtracting. However, I would very much like to combine this into one function if possible.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,289
Messages
5,571,323
Members
412,382
Latest member
Langtn02
Top