Posted to microsoft.public.excel.programming

nrage21[_20_] nrage21[_20_] is offline

external usenet poster

Posts: 1

Adding Time

I have a little problem, that I know you guys can help me with...

I have a column full of Times... they are in the following format:

Column A
0H:8M
9H:39M
14H:46M ... and so on.

What do I need to do to add these,... result should be 24H:33M usin
the forementioned rows??? (scratching head)

Once someone cracks this... I want to create a macro to run thi
operation automatically.

Thanks in advance!
-Larry-
VBA Amateu

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 time	khaled	Excel Discussion (Misc queries)	4	November 12th 08 07:53 PM
adding time	GrayC011182	Excel Worksheet Functions	2	June 4th 07 08:33 PM
Adding time	Steved	Excel Worksheet Functions	13	May 17th 07 09:15 AM
Time log adding time from separate sheets	teastman	New Users to Excel	1	December 31st 05 04:14 PM
Adding time to date-time formatted cell	tawtrey(remove this )@pacificfoods.com	Excel Discussion (Misc queries)	4	August 12th 05 10:53 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us