IF Formula working with work shifts

**DGutterud** · 05-19-2011, 01:40 PM

I am working on an hourly shift schedule and would like to do the following:

I have it set up so that the time sheduled per shift is calculated.

What I would like to do is have it deduct 30 minutes if a person works over 6 hours and 1 minute, or return the actual hours scheduled if the shirf is not over 6 hours and 1 minute.

I can get it to deduct the 30 minutes, but it does it for every case :o(

**JBeaucaire** · 05-19-2011, 02:14 PM

Without your workbook to look at it's unclear if you're doing match on Time Values or if you've already converted the time to standard decimals.

A1 = Start Time
B1 = End Time
C1 = Time worked as a decimal (this formula calculates correct time even for shifts going past midnight)
=(B1-A1+(A1>B1)) * 24

D1 = break calculation
=IF(C1>6, 0.5, 0)

E1 =C1-D1
If the hours worked have been calculated in

**DGutterud** · 05-19-2011, 05:43 PM

I have attached the form I am working on. I am a novice so it may not look like it should, but I can get most of it to work

I would like the row under the daily hour calculation to give the modified amount if the time worked is over 6 hours and one minute.

Thanks for the info.