Posted to microsoft.public.excel.misc

Wanna Learn Wanna Learn is offline

external usenet poster

Posts: 318

concatenate time from 3 columns

Thank you - perfect....

"Gary''s Student" wrote:

=TEXT(A1,"hh:mm") & "-" & TEXT(C1,"hh:mm AM/PM")

--
Gary''s Student - gsnu200732

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
day and time concatenate	P Boric	Excel Worksheet Functions	7	December 8th 09 01:43 AM
Is there a way to concatenate date and time?	chazparks	Excel Discussion (Misc queries)	5	September 20th 06 01:14 AM
Concatenate two columns?	uma	Excel Worksheet Functions	1	April 19th 06 09:46 AM
Concatenate/Time Functions	brianwakin	Excel Worksheet Functions	2	September 1st 05 07:25 PM
How to Concatenate Time with some operator?	changeable	Excel Worksheet Functions	1	November 3rd 04 01:01 PM

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

About Us

"It's about Microsoft Excel"