problem trying to combine column of dates and time

[fumusic]

I have column of dates in A in the format dd/mm/yyyy.
In column B I have list of times in the format hh.mm. Unfortunately, as you can see, I have used a numbering system to log the times and the time is down as 20.10 instead of 20:10
I want to combine these two columns in column C so that I get "dd/mm/yy - hh:mm" ,example 20/06/20 - 14:46
I have tried to use =TEXT(A2,"dd/mm/yy")&" - "&TEXT(B2,"hh:mm") but due to column B being the wrong format, it throws out the wrong time.
Please help.

[Vraag en antwoord]

give it a try

Please Login or Register  to view this content.

[Fluff13]

How about
=TEXT(A2,"dd/mm/yy")&" - "&TEXT(DOLLARDE(B2,60)/24,"hh:mm")

[fumusic]

excellent! that works brilliantly! thanks!
just tried to add to your reputationa and it says i need to spread the reputation around before i can give to you again.

[Fluff13]

Not sure which of us you're talking to, but glad we could help & thanks for the feedback.

[Vraag en antwoord]

A combination of # 2 and # 3

Please Login or Register  to view this content.