ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I add multiple times together (https://www.excelbanter.com/excel-discussion-misc-queries/25658-how-do-i-add-multiple-times-together.html)

Playhouse pm

How do I add multiple times together
 
Hi does anyone know how I can add multiple times togther and get the anser in
hours and minutes. I have formatted the cell for time however when I atosum I
keep getting an answer that is incorrect. Any help?
Thanks
D

Dave Peterson

Maybe it was just a formatting problem.

Try a custom format of:
[hh]:mm





Playhouse pm wrote:

Hi does anyone know how I can add multiple times togther and get the anser in
hours and minutes. I have formatted the cell for time however when I atosum I
keep getting an answer that is incorrect. Any help?
Thanks
D


--

Dave Peterson


All times are GMT +1. The time now is 09:10 PM.

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