Time calculations
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. |
Time calculations
Try this
=IF((B9-A9)0.3542,(B9-A9)-0.0208,(B9-A9)) -- |
Time calculations
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. |
Time calculations
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. |
All times are GMT +1. The time now is 02:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com