Concatenate/Time Functions
 

I wrote the following formula to attempt to convert decimal values in two
separate cells to a h:mm format in one cell:
=CONCATENATE(TEXT(B7/24,"h:mm")," - ",TEXT(C7/24,"h:mm"))

Cell B7 has a value of .29... and cell c7 has a value of .66. The formula
produced the following result: "0:17 - 0:40". This is exactly the format I
was looking for but the value I was looking for was " 7:00 PM - 4:00 PM".
What am I doing wrong? Any feedback would be very much appreciated. Thanks.

--
Brian

=CONCATENATE(TEXT(B7,"h:mm AM/PM")," - ",TEXT(C7,"h:mm AM/PM"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"brianwakin" wrote in message
...
I wrote the following formula to attempt to convert decimal values in two
separate cells to a h:mm format in one cell:
=CONCATENATE(TEXT(B7/24,"h:mm")," - ",TEXT(C7/24,"h:mm"))

Cell B7 has a value of .29... and cell c7 has a value of .66. The formula
produced the following result: "0:17 - 0:40". This is exactly the format
I
was looking for but the value I was looking for was " 7:00 PM - 4:00 PM".
What am I doing wrong? Any feedback would be very much appreciated.
Thanks.

--
Brian

thank you very much. That worked perfect!!
--
Brian


"Bob Phillips" wrote:

=CONCATENATE(TEXT(B7,"h:mm AM/PM")," - ",TEXT(C7,"h:mm AM/PM"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"brianwakin" wrote in message
...
I wrote the following formula to attempt to convert decimal values in two
separate cells to a h:mm format in one cell:
=CONCATENATE(TEXT(B7/24,"h:mm")," - ",TEXT(C7/24,"h:mm"))

Cell B7 has a value of .29... and cell c7 has a value of .66. The formula
produced the following result: "0:17 - 0:40". This is exactly the format
I
was looking for but the value I was looking for was " 7:00 PM - 4:00 PM".
What am I doing wrong? Any feedback would be very much appreciated.
Thanks.

--
Brian