Hi experts,
Another problem with my last data set. I have the following data set where the users take part in 4 exercises.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The result I need is as follows.
<colgroup><col><col></colgroup><tbody>
</tbody>
I tried to achieve this result by adding a helper column to the data set and getting the time differences and then doing a SUMIF in the Total Time column. It works for smaller data sets but not for larger sets of data. Hence Im looking for a solution without the use of a helper column.
I only need help with the column "Total Time".
Many thanks.
Another problem with my last data set. I have the following data set where the users take part in 4 exercises.
Time Started | Time Ended | |
Exercise 1 | 19:00 | 20:00 |
Exercise 2 | 20:00 | 21:00 |
Exercise 3 | 21:00 | 22:00 |
Exercise 1 | 22:00 | 23:00 |
Exercise 4 | 23:00 | 0:00 |
Exercise 2 | 0:00 | 1:00 |
Exercise 3 | 1:00 | 2:00 |
Exercise 1 | 2:00 | 3:00 |
Exercise 4 | 3:00 | 4:00 |
Exercise 3 | 4:00 | 5:00 |
Exercise 2 | 5:00 | 6:00 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The result I need is as follows.
Total Time | |
Exercise 1 | 3:00:00 |
Exercise 2 | 3:00:00 |
Exercise 3 | 3:00:00 |
Exercise 4 | 2:00:00 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I tried to achieve this result by adding a helper column to the data set and getting the time differences and then doing a SUMIF in the Total Time column. It works for smaller data sets but not for larger sets of data. Hence Im looking for a solution without the use of a helper column.
I only need help with the column "Total Time".
Many thanks.