Thank you every one in advance for your help and contribution to Excel Forum. I am trying to find out if there is a formulate that looks at column A (TTime) and checks to see if there are more than tow occurrences of the same date and to calculate elapsed time (in column I) between to times in a particular date only if there are more than two clock ins and clock outs. For example at the attached example workbook, on August 14, 2017 there are two clock ins and clock outs. The only way I can calculate the time elapsed from the first clock out and and second clock in is by subtracting the second clock in time from first clock out. Cell reference: G28-G27, which gives me a total of 0:19:37. Then add the total elapsed time at the bottom of column I. I am only interested in calculating the elapsed times if there are more than 2 occurrences of clock ins and clock outs. Also you will notice that on 11/13/2017, there are 3 clock ins and 3 clock outs. I'd like to calculate the elapsed time between these times and add them up.
I would greatly appreciate your help and time.
Bookmarks