Counting multiple occurrences in a day

hello! Vvelarde

Thanks so much for setting this up! Waaaay over my head. Not sure I understand your approach but will review carefullly.

However, you have a column called "Working Time ". It is showing "12/30/1899" for all rows. For "Working Time", I wanted to capture the total duration the genset has run for each day - so for instance, on June 2, the genset run twice. I'd like to know the total length of time ( sum of both run occurences for that day ).

The last metric - "Average duration" looks at the duration of each specific run instance, then I intend to take an average of all those instances by day or week or month. 

Hope this helps.  Many thanks.