ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I need to add and subtract time cells. ie. 13:45 minus 13:58 (https://www.excelbanter.com/excel-discussion-misc-queries/51635-i-need-add-subtract-time-cells-ie-13-45-minus-13-58-a.html)

Mschertz

I need to add and subtract time cells. ie. 13:45 minus 13:58
 
I am having trouble manipulating cells formated to time. I need to be able
to add, sum, subtract the entered cells, and then work with the results of
the addition etc.

Alan

I need to add and subtract time cells. ie. 13:45 minus 13:58
 
To add times and prevent them being converted into days, Cusstom Format as
[hh]:mm:ss
Regards,
Alan.
"Mschertz" wrote in message
...
I am having trouble manipulating cells formated to time. I need to be able
to add, sum, subtract the entered cells, and then work with the results of
the addition etc.





All times are GMT +1. The time now is 02:37 AM.

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