ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add time formatted cells together beyond 24hrs? (https://www.excelbanter.com/excel-discussion-misc-queries/119810-how-do-i-add-time-formatted-cells-together-beyond-24hrs.html)

Dorothy

How do I add time formatted cells together beyond 24hrs?
 
I am trying to set up a time sheet to work out overtime and as soon as I have
accumulated more than 24 hours it goes back to 01:00.

Teethless mama

How do I add time formatted cells together beyond 24hrs?
 
Format cells as
[h]:mm (not hh:mm)

"Dorothy" wrote:

I am trying to set up a time sheet to work out overtime and as soon as I have
accumulated more than 24 hours it goes back to 01:00.



All times are GMT +1. The time now is 12:42 PM.

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