Excel Time To Text and concatenate

February 11, 2011 at 01:10:20
Specs: Windows Vista
Does any one know an easy way of converting a time field (hh:mm) into text....

so 07:00:00 in time format would become 07:00 in text format etc etc. I need to do this as I have 2 columns of times that I need to concatenate to create one cell of times so:-

Column A Column B
07:00:00 09:00:00 Becomes 07:00-09:00 in text


See More: Excel Time To Text and concatenate

Report •

February 11, 2011 at 06:54:38
How about:

=TEXT(A1,"hh:mm") & "-" & TEXT(B1,"hh:mm")

Anytime you you use the CONCATENATE function or Concatenate operator (&) the result will always be text.

The issue you have is that Excel stores dates and times as numbers, so you have to convert the time to Text prior to concatenating the time values or you will get the text version of the number that represents that time.

Does that make sense?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 11, 2011 at 13:07:10
Absolutely brilliant !!

Many, many thanks for this..

Report •

Related Solutions

Ask Question