ExcelBanter - Adding a date and time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding a date and time (https://www.excelbanter.com/excel-worksheet-functions/16257-adding-date-time.html)

Skip4t4

Adding a date and time

I have a date in column A and a time in column B and I would like to have the
date and time in column C

A1: 20/02/2005
B1: 09:32
C1: 20/02/2005 09:32

Thanks....

Skip4t4

It's OK, I got it thanks
doh!!

"Skip4t4" wrote:

I have a date in column A and a time in column B and I would like to have the
date and time in column C

A1: 20/02/2005
B1: 09:32
C1: 20/02/2005 09:32

Thanks....

All times are GMT +1. The time now is 07:26 AM.