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

lillian

Board Regular
Joined
Oct 12, 2005
Messages
72
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?
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
So close:

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

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,253
Members
412,709
Latest member
Rishu
Top