Forum Discussion
Solved
Shift end time and overnight rest break
I have an activity logger and cells on "Day 1" A16 to B33 are start and end times. A16 is populated from an entry in C10 and G10 is populated from the last time entered in B16:33. The array may be fu...
Formula for G10:
=LOOKUP(2,1/(B16:B32<>"")/(MOD(B16:B32 - A16:A32, 1) <= TIME(9, 0, 0)), B16:B32)
Maybe it will work now
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?