#1   Report Post  
Myrna Larson
 
Posts: n/a
Default

YOu can add the values if the cells contain the time values 12:30:00 and
1:45:45, but not if they contain the exact text (with hr, min, and sec
embedded) that you show in your message.

On Mon, 19 Sep 2005 11:21:05 -0700, "Neville"
wrote:

How can I add two or more sets of hours:minutes:seconds? For example, if I
add 12hr30min00sec to 1hr45min45sec I should get 14hr15min45sec.

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
time sheet calculations emmcee Excel Worksheet Functions 7 August 20th 05 12:26 PM
Time Calculations Paul T Excel Worksheet Functions 1 April 23rd 05 04:02 AM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM
Time calculations & text conversions Kenny Hubbard Excel Discussion (Misc queries) 1 February 5th 05 10:15 PM
Time Sheet calculations dkostel Excel Worksheet Functions 2 November 23rd 04 10:11 PM


All times are GMT +1. The time now is 02:48 PM.

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

About Us

"It's about Microsoft Excel"