Hello,
I'm creating a pivot table and would like to sort by the below text under Column Time In Queue.
What I've been able to do so far is convert the days, hours, minutes, seconds into a "d.h:mm:ss" format but it looks messy and I'm not sure it's correct.
<tbody>
</tbody>
<tbody>
</tbody>
I'm creating a pivot table and would like to sort by the below text under Column Time In Queue.
What I've been able to do so far is convert the days, hours, minutes, seconds into a "d.h:mm:ss" format but it looks messy and I'm not sure it's correct.
Time In Queue | Invoice Amount | Vendor ID |
22 days 6 hours 45 minutes 51 seconds | $20.26 | 326553 |
21 days 21 hours 3 minutes 38 seconds | $244.12 | 4142 |
21 days 20 hours 30 minutes 55 seconds | $3,271.25 | 9373 |
16 days 2 hours 44 minutes 9 seconds | $2,108.49 | 340233 |
14 days 11 hours 22 minutes 6 seconds | $90.00 | 342924 |
14 days 9 hours 20 minutes 28 seconds | $86.48 | 331774 |
13 days 17 hours 59 minutes 5 seconds | $10,590.01 | 29130 |
13 days 17 hours 58 minutes 15 seconds | $10,451.08 | 29130 |
8 days 20 hours 20 minutes 26 seconds | $1,221.96 | 6156 |
8 days 20 hours 18 minutes 10 seconds | $249.97 | 6156 |
<tbody>
</tbody>
Time in Queue |
<tbody> </tbody> |
<tbody> </tbody> | Minute | Second | Time Value |
<tbody> </tbody> | d.h:mm:ss |
<tbody> </tbody> | |||||
22 days 6 hours 45 minutes 51 seconds | 22 | 6 | 45 | 51 | '=TIME(E2,F2,G2) |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>