Can you combine two cells to create a time range in a third cell?

**ndmerc8** · 04-16-2012, 06:09 PM

Okay, this is my first query so let me know if there's any key info missing, thanks.

I reckon our works uses Excel 2000.
I've got a spreadsheet where I'm calculating costs based on a shift pattern and where there are a number of VLookups in place.
I have a time (hh:mm) in one cell (A1) and another time in the same format in a 2nd cell (A2).
The two have to be separate as the difference confirms the maximum shift duration & there's a calulcation running off this which drives a Vlookup.
I now need to display the two times in one cell showing them as a range (hh:mm - hh:mm).
I've tried CONCATENATE and =A1& " - "&A2 but I believe these will generally only work with text/general formatting.
Is there a way to combine cells A1 & A2 in the range format given?

Thanks in adavnce for any help you can offer.

Cheers.

Nick

**Richard Buttrey** · 04-16-2012, 06:14 PM

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.