Meal Break on Time Sheet in Excel
Thank you John, that did it :-)
"John Michl" wrote:
Change the data validation to:
Settings: Allow Time
Data Greater than or Equal to
Start Time: A1 + 1/48
Where A1 is the cell that contains the log out time. 30 minutes is
also 1/48 of a day so adding that to the log out time would give the
earliest log in time. Note this will be very picky. 29 minutes and 59
seconds would not be allowed.
- John
|