How to stop time format changing when I merge cell contents?

C

CatKween

I am trying to merge to time cells, (both set to English (United States),
Time Type 13:30) both cells display correctly where I entered them (9:00 and
9:45) but when I merge the cell contents using the function =A4&" - "&B4 I
get the result 0.375 - 0.406 instead of 9:00 - 9:45 as expected. The
destination cell has the same time settings as the two original cells.

How do I stop the times converting to decimals and get them to display the
way I want them too?
 
B

Bernard Liengme

Gordon has given you the correct answer (as always).
Here is the reason for it:
Excel stores dates as serial numbers and times as factions of a 24-hr day
(is there any other type <gr>?)
So A1&"-"&B1 will display: number "-" number rather than time "-" time
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top