Calculating sum of time breaks with multiple time stamps

%3CLINGO-SUB%20id%3D%22lingo-sub-2028377%22%20slang%3D%22en-US%22%3ECalculating%20sum%20of%20time%20breaks%20with%20multiple%20time%20stamps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2028377%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20that%20consists%20date%2C%20worker%20name%20and%20time%20stamp%20(hour%3Amin%3Asec)%20in%20one%20row.%20Time%20stamp%20means%20that%20a%20worker%20uses%20a%20bar%20code%20reader%20to%20read%20information.%20Eg.%20is%20working%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20have%20a%20function%20that%20calculates%20the%20sum%20of%20%22too%20long%20breaks%22%20by%20each%20worker%2C%20by%20each%20day.%20Eg.%26nbsp%3B%20January%205th%2C%20worker%20John%20Doe%20had%203.5%20hours%2020%20minutes%20of%20total%20break%20time.%20I%20should%20be%20able%20to%20define%20the%20brake%20time%20being%20either%2015%20min%2C%2030%20min%20or%201%20hour.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2028377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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