View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default Combining 2 cells

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