Time calculations

[NEHicks]

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(D5>I4, D5-I3) I4=0.333333 and I3=0.02083333

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

 

[Chris Premo]

Try this


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


--

 

[T. Valko]

see your other post

 

[ob-server]

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