I'm working on a Frequency Distribution for time values. I have separate incidents with a start date and resolved date. I used an excel formula to retrieve the time difference between the two.
I'm trying to make a pivot table with Time Elapsed but it shows up as 00:00:00.
Any ideas of what's going on or how I can make it work.
<tbody>
</tbody>
This is how the row looks by itself, but when I make a pivot table of data similar to this, it appears as
<tbody>
</tbody>
Why does the time continue to show as 00:00:00 when there's data ?
I'm trying to make a pivot table with Time Elapsed but it shows up as 00:00:00.
Any ideas of what's going on or how I can make it work.
Incident Number: | Start Date | End Date | Time Elapsed: |
Ally# INC0839013 : | 12/3/18 11:37 PM | 12/3/18 11:44 PM | 0:0:07:00 |
<tbody>
</tbody>
This is how the row looks by itself, but when I make a pivot table of data similar to this, it appears as
Row Labels | Sum of Time Elapsed |
Ally# INC0839013 : | 00:00:00 |
<tbody>
</tbody>
Why does the time continue to show as 00:00:00 when there's data ?
Last edited: