Using date and time to be able to look back within 24 hours to see how many hours worked.
I.e.
Worked from yesterday 1200-1415 and then from 1530-1730. This would equal out to 4:15. If i am scheduled to work at 0800-1200 today, i would not be legal to start work until 0815 using a lookback formula.
A1 cell has start date and time
A2 cell has end date and time
A3 cell has start date and time
A4 cell has start date and time
Above are yesterdays
A5 would show the calc of when the legal time to start today.
Anybody have an idea. Thanks in advance