In Microsoft Excel 5.0 and in later versions of Excel, you can enter times that exceed 24 hours by using a number format that includes [h]. The square brackets around the "h" instruct Excel to calculate times beyond 24-hour intervals, which allows you to enter times that exceed 24 hours.
How do I show time longer than 24 hours in Excel?
To display the time as more than 24 hours, select cell B4. On the Home tab, in the Cells group, choose Format, and then choose Format Cells. In the Format Cells box, choose Custom in the Category list. In the Type box, at the top of the list of formats, type [h]:mm;@ and then choose OK.
How do I calculate elapsed time in Excel?
Formula 2.
Another simple technique to calculate the duration between two times in Excel is using the TEXT function: Calculate hours between two times: =TEXT(B2-A2, "h") Return hours and minutes between 2 times: =TEXT(B2-A2, "h:mm") Return hours, minutes and seconds between 2 times: =TEXT(B2-A2, "h:mm:ss")