Exactly what I required.

Thankyou.

"Peo Sjoblom" wrote:

One possible way

=B5&TEXT(C5,"hhmm")


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Steved" wrote in message
...
Hello from Steved

I've got a cell with 5:00 I've converted it to 0510 when highlighting the
cell it shows 05:10:00.

Cell B5 has 4701, Cell C5 has 5:10

please how do I combine the two cells into D5 to look like 47010510

As at the moment I am getting 4710.215277777777778

Thanks for your time