ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   ADD TIME IN EXCESS OF 24 HOURS (https://www.excelbanter.com/excel-worksheet-functions/9420-add-time-excess-24-hours.html)

Elizabeth

ADD TIME IN EXCESS OF 24 HOURS
 
i want to input time as hh:mm and add this together carrying the total
forward. When i go over 24 hours the figure resets to zero

Peo Sjoblom

Actually only the display starts over again, the numbers are there, use
custom format [hh]:mm or for decimal hours multiply with 24 and format as
general


Regards,

Peo Sjoblom

"Elizabeth" wrote:

i want to input time as hh:mm and add this together carrying the total
forward. When i go over 24 hours the figure resets to zero



All times are GMT +1. The time now is 11:24 PM.

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