Calculating sum of time breaks with multiple time stamps

Copper Contributor

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. 

0 Replies