ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel - Time calculation (https://www.excelbanter.com/excel-discussion-misc-queries/872-excel-time-calculation.html)

Leyland

Excel - Time calculation
 
How do I add elapse times which total over 24 hours. All I keep getting is
the remainer over 24 hours ie. If the total is 26 hours the result only shows
2!

Peo Sjoblom

It is just the display using default format,
use custom format [hh]:mm

Regards


Peo Sjoblom

"Leyland" wrote:

How do I add elapse times which total over 24 hours. All I keep getting is
the remainer over 24 hours ie. If the total is 26 hours the result only shows
2!



All times are GMT +1. The time now is 03:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com