LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posts: n/a
Default add hours & minutes to other hours & minutes to receive total hou.

  #2   Report Post  
Posts: n/a

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

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.


"Wes" wrote:


  #3   Report Post  
Bob Phillips
Posts: n/a


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



(remove nothere from the email address if mailing direct)

"Wes" wrote in message

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
Adding hours and minutes Patrick Excel Worksheet Functions 16 June 18th 08 09:24 PM
Time - Hours and Minutes Mark Zak Excel Discussion (Misc queries) 4 February 18th 05 02:51 AM
convert hours and minutes to minutes idaho Excel Discussion (Misc queries) 2 January 27th 05 10:45 PM
add column of minutes, show total in hours & minutes glider pilot Excel Worksheet Functions 1 December 30th 04 11:27 PM
calculate average hours and minutes llstephens Excel Worksheet Functions 4 November 30th 04 04:47 PM

All times are GMT +1. The time now is 06:26 AM.

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

About Us

"It's about Microsoft Excel"