excel time

%3CLINGO-SUB%20id%3D%22lingo-sub-3017116%22%20slang%3D%22en-US%22%3Eexcel%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3017116%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20pivot%20time%20durations%20for%20a%20month%2C%20because%20it%20is%20for%20the%20whole%20month%20the%20time%20is%20greater%20that%2024hrs%2C%20when%20I%20want%20to%20pivot%20the%20times%20it%20comes%20up%20as%2000%3A00%3A00%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3017116%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3017217%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3017217%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1233231%22%20target%3D%22_blank%22%3E%40Bernadine945%3C%2FA%3E%26nbsp%3BUse%20a%20custom%20format%20with%20square%20brackets%20around%20the%20h-part%20like%20%5Bh%5D%3Amm%3Ass%20to%20make%20it%20a%20%3CSTRONG%3Eduration%3C%2FSTRONG%3E.%20hh%3Amm%3Ass%20represents%26nbsp%3B%3CSTRONG%3Etime%3C%2FSTRONG%3E%20and%20restart%20after%2024%20hours%2C%20just%20like%20on%20a%20digital%20clock.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi 

 

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 

1 Reply

@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.