This website has been so helpful. I am devouring the archives. I have a question though that I don't think has been answered before.
Our workplace is using google sheets to let our union employees clock in and clock out remotely. Our union workers have many special rules/guidelines for tracking time that I incorporated into our original timesheet. Life was good. BUT.... now they are working past midnight and google sheets is getting confused. I tried to add multiple lines per day and have our employees enter data like this: If working 6:30pm-4am, enter 6:30pm-12am on line 1, 12am-4am on line 2.
Here is the spreadsheet. I have an example (Monday) on the page that works perfectly. When i copy and paste that example into other cells, those cells compute correctly too. But when i then clear the cells and try to enter new data that crosses past midnight, I get the #### error.
Any reason why there is one magical set of numbers that work and nothing else does? For convenience, I turned all the 'invisible' formula garble to a visible grey color on the right side of the timesheet.
https://docs.google.com/a/frymanmana...it?usp=sharing
thank you.
Bookmarks