I need the formula that will allow me to subtract a 1/2hr lunch if an hour
result is equal to or greater than 8.5 hours.

A B C D E
Start Time End Time OT Hours Total worked hours
7:00 15:30 8:30 8.0

This is an example of what my answer should be.

I have tried so many formulas that I thought should work but it doesn't
carry over to other rows. =SUM(D5I4, D5-I3) I4=0.333333 and I3=0.02083333

My brain is mush so I am hoping one of you could help.

Try this


=IF((B9-A9)0.3542,(B9-A9)-0.0208,(B9-A9))


--

see your other post

--
Biff
Microsoft Excel MVP


"NEHicks" wrote in message
...
I need the formula that will allow me to subtract a 1/2hr lunch if an hour
result is equal to or greater than 8.5 hours.

A B C D E
Start Time End Time OT Hours Total worked hours
7:00 15:30 8:30 8.0

This is an example of what my answer should be.

I have tried so many formulas that I thought should work but it doesn't
carry over to other rows. =SUM(D5I4, D5-I3) I4=0.333333 and
I3=0.02083333

My brain is mush so I am hoping one of you could help.

A B C D E
Start Time End Time OT Hours Total worked hours
7:00 15:30 8:30 8.0

This is an example of what my answer should be.

for a case below ,

Start Time End Time OT Hours Total worked hours
7:30 15:30 8:00 8.0

shall we consider Total worked hours will be 8.0 also ?

regards


"NEHicks" wrote:

I need the formula that will allow me to subtract a 1/2hr lunch if an hour
result is equal to or greater than 8.5 hours.

A B C D E
Start Time End Time OT Hours Total worked hours
7:00 15:30 8:30 8.0

This is an example of what my answer should be.

I have tried so many formulas that I thought should work but it doesn't
carry over to other rows. =SUM(D5I4, D5-I3) I4=0.333333 and I3=0.02083333

My brain is mush so I am hoping one of you could help.