Jan 03 2021 10:40 PM
Hi everyone,
I have an excel that consists date, worker name and time stamp (hour:min:sec) in one row. Time stamp means that a worker uses a bar code reader to read information. Eg. is working :)
I would like to have a function that calculates the sum of "too long breaks" by each worker, by each day. Eg. January 5th, worker John Doe had 3.5 hours 20 minutes of total break time. I should be able to define the brake time being either 15 min, 30 min or 1 hour.