Hi
Use in F7, G7, H7 the followingFormula:
=IF(K7>11/24,11/24,K7)Formula:
=IF(E7>B7,E7,E7+1)-B7-IFERROR((D7-C7),0)Formula:
=IF(K7>11/24,K7-11/24,0)
and copy down
Hi
Use in F7, G7, H7 the followingFormula:
=IF(K7>11/24,11/24,K7)Formula:
=IF(E7>B7,E7,E7+1)-B7-IFERROR((D7-C7),0)Formula:
=IF(K7>11/24,K7-11/24,0)
and copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks