Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 27th 04, 12:01 AM
Tricia
 
Posts: n/a
Default 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



  #2   Report Post  
Old November 27th 04, 12:25 AM
Gord Dibben
 
Posts: n/a
Default

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


  #3   Report Post  
Old November 27th 04, 12:29 AM
tjtjjtjt
 
Posts: n/a
Default

=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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CALCULATE HOURS WORKED Calculation of hours worked. Excel Discussion (Misc queries) 3 January 20th 05 06:01 PM
Formatting Hours and Minutes Anthony Slater Excel Discussion (Misc queries) 2 January 20th 05 02:03 PM
Adding minutes to time Randberger Excel Discussion (Misc queries) 4 January 19th 05 08:49 PM
How do I convert times from hours to minutes? kkrebs Excel Discussion (Misc queries) 5 December 30th 04 06:13 PM
Problems calculating total hours LolaK Excel Discussion (Misc queries) 1 December 14th 04 04:23 PM


All times are GMT +1. The time now is 05:53 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017