ANSWERS: 1
-
It would be a very unwieldy formula, just 4 days gives something like: =SUM(IF(C5-B5<5/24,C5-B5,C5-B5-0.5/24),IF(C6-B6<5/24,C6-B6,C6-B6-0.5/24),IF(C7-B7<5/24,C7-B7,C7-B7-0.5/24),IF(C8-B8<5/24,C8-B8,C8-B8-0.5/24)) It would be far easier and less prone to error to just drag your formula through cells D5:D11 with the Fill Handle, put =SUM(D5:D11) in cell E11 and then hide Column D if you don't want to see it. However, a problem arises if the total number of hours is greater than 24, so I would format cells D5:D11 as General and put this formula in place of your original one and use the Fill Handle to drag it down: =IF(C5-B5<5/24,(C5-B5)*24,((C5-B5)*24)-0.5) Again hide the column if you don't want to see it and put =SUM((D5:D11) in cell E11.
Copyright 2023, Wired Ivy, LLC

by 