SOLVED

Time Format

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3145493%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ETime%20Format%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3145493%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHow%20to%20format%20time%20that%20exceeds%2024%20hours%20to%20reflect%20an%20accurate%20number%20(example%20-%2025%20hours%20shows%20as%201%20hour%20-%20need%20it%20to%20show%2025%20hours).%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThank%20you.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3145493%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

How to format time that exceeds 24 hours to reflect an accurate number (example - 25 hours shows as 1 hour - need it to show 25 hours).

 

Thank you.

5 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@JPCFSP 

Apply the custom number format

[h]:mm

or, if you need seconds too

[h]:mm:ss

@JPCFSP Excel understands days as numbers, and so hours of a day a fractions of 1. To that end, I set out the example below:

 

KallunWillock_0-1644440144645.png

Divide 25 by 24 hours = 1.04 = 25:00, with custom number formatting [h]:mm

I hope that helps.

@KallunWillock 

 

Thank you. I might try that. I heard from Hans, and his recommendation worked like a charm.

Thank you. This worked really well!!

@Hans Vogelaar This worked really well. Thank you so much.