Darkzler
New Member
- Joined
- Sep 25, 2015
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
Hi everyone, thanks for having me here.
I got the following setup:
I need to make a pivot table that lists each ID in column G with the total amount of time it takes from earliest time in column J to the latest.
Example of how it would look like:
ID Total time
TRP1 - 03:00:00
TRP2 - 05:00:00
TRP3 - 01:00:00
Is this possible in some way?
I got the following setup:

I need to make a pivot table that lists each ID in column G with the total amount of time it takes from earliest time in column J to the latest.
Example of how it would look like:
ID Total time
TRP1 - 03:00:00
TRP2 - 05:00:00
TRP3 - 01:00:00
Is this possible in some way?
Last edited: