Formatting a time range question (ex. 08:30 - 18:00)

[lillian]

Hiya,

I have a coupla columns - one with a start time, one with an end time. I want to copy them & dump a " - " between them. I've been trying this formula:

=TEXT($H2, "HH:MM") & " - " & ($J2)

With no luck. That means the first cols data comes out just right, but the second bit of data is not formatted in "HH:MM" format.

I've tried a few variations:

=TEXT($H2) & " - " & ($J2, "HH:MM") - result: too few arguments
=TEXT($H2) & " - " & ($J2) - result: nothing is formatted (shows up as 0.715-0.725, as a for instance)
=TEXT(($H2) & " - " & ($J2), "HH:MM") - result: nothing formatted (as the line above)

I don't want to lose the original columns, or I'd give concatenate a try.

any ideas?

 

[Seti]

So close:

=TEXT($H2, "HH:MM") & " - " & TEXT($J2, "HH:MM")

 

[lillian]

Yay!

It works!