Reply to thread

Message: [QUOTE="CatKween, post: 3862994"] 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? [/QUOTE]