View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

=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