ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   add hours & minutes to other hours & minutes to receive total hou. (https://www.excelbanter.com/excel-worksheet-functions/15606-add-hours-minutes-other-hours-minutes-receive-total-hou.html)

Wes

add hours & minutes to other hours & minutes to receive total hou.
 
help

Basil

A1 + A2 or something similar.

The addition should work but you would want to ensure the cell format
(number) displays what you want it to. Try going to formatcells...
click on the number tab and go to Custom. In the box, type [H]:mm
Be sure to put the square brackets around the H.

You see if, say you add 21:00 to 09:00, The default would generally show
06:00 as the answer - this is because what you don't see is that it is 06:00
+ 1 day - you would have to change the format to include date to see this
difference.

I hope this is clear enough - my english is getting ropey!

PS You may want to consider giving us more info next time you post.

Basil


"Wes" wrote:

help


Bob Phillips

=A1+A2

as simple as that, format the result cell as [h]:mm

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Wes" wrote in message
...
help





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

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