I am trying to pivot time durations for a month, because it is for the whole month the time is greater that 24hrs, when I want to pivot the times it comes up as 00:00:00
@Bernadine945 Use a custom format with square brackets around the h-part like [h]:mm:ss to make it a duration. hh:mm:ss represents time and restart after 24 hours, just like on a digital clock.
