View Single Post
  #1   Report Post  
FSt1
 
Posts: n/a
Default 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