ExcelBanter - Date time problem

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Date time problem (https://www.excelbanter.com/excel-discussion-misc-queries/47199-date-time-problem.html)

FSt1

Date time problem

hi all,
I have a date and one cell and a time in 24 other cells at 1 hour increments.
how do i combine the date cell with the time cells
example
in a1 =9/26/05
in b1 = 08:00
results in c1 would = 9/26/05 8:00 AM

Thanks
FJS

Niek Otten

=A1+B1

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"FSt1" wrote in message
...
hi all,
I have a date and one cell and a time in 24 other cells at 1 hour
increments.
how do i combine the date cell with the time cells
example
in a1 =9/26/05
in b1 = 08:00
results in c1 would = 9/26/05 8:00 AM

Thanks
FJS

All times are GMT +1. The time now is 05:39 PM.