Hello,

If I have the below data, I want to find out the total duration on each employee’s last day of work.  This would essentially be the end time of the last event, minus the start time of the first event that starts on the same date.  The part I can’t figure out is how to vary the formula for a different number of events.

So, with this example:  ID 123 has 2 events on 5/4, so the formula is C7 – B6.

But ID 456 has 4 events on the last day (5/8), so the formula is C15 – B12

Note that it’s based on the same start date — so for ID 789, the very last events starts before midnight but ends after midnight.  So it would be C21 – B18, since both of those events start on 5/4

Thank you!

​Hello, If I have the below data, I want to find out the total duration on each employee’s last day of work.  This would essentially be the end time of the last event, minus the start time of the first event that starts on the same date.  The part I can’t figure out is how to vary the formula for a different number of events. So, with this example:  ID 123 has 2 events on 5/4, so the formula is C7 – B6.But ID 456 has 4 events on the last day (5/8), so the formula is C15 – B12Note that it’s based on the same start date — so for ID 789, the very last events starts before midnight but ends after midnight.  So it would be C21 – B18, since both of those events start on 5/4 Thank you!        Read More

​