ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   adding hours and minutes (https://www.excelbanter.com/new-users-excel/4524-adding-hours-minutes.html)

Tricia November 27th 04 12:01 AM

adding hours and minutes
 
Hi what format do I need for the cells in excel for adding time as in 01:35
(one hour thirty five minutes) + 12:35 = 14:10.

Or where can I find a tutorial or example.

Thanks Tricia



Gord Dibben November 27th 04 12:25 AM

Chip Pearson has examples and very good info on working with times and dates.

http://www.cpearson.com/excel/datetime.htm#AddingTimes

Gord Dibben Excel MVP

On Sat, 27 Nov 2004 00:01:57 -0000, "Tricia"
wrote:

Hi what format do I need for the cells in excel for adding time as in 01:35
(one hour thirty five minutes) + 12:35 = 14:10.

Or where can I find a tutorial or example.

Thanks Tricia



tjtjjtjt November 27th 04 12:29 AM

=A1+B1 will do it.
What you may need to do is change the Cell Format for the cells to:
[h]:mm
You can do this by selecting the cell and going to:
Format | Cells | Number
Change to Custom and type [h]:mm in the line provided.

For details about working with time, see Chip Pearson's page:
http://www.cpearson.com/excel/datetime.htm#AddingTimes

tj

"Tricia" wrote:

Hi what format do I need for the cells in excel for adding time as in 01:35
(one hour thirty five minutes) + 12:35 = 14:10.

Or where can I find a tutorial or example.

Thanks Tricia





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

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