Date time problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[NEWBIE] date/time diff 4
Calculate elapsed time excluding specific timeframe 10
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? 5
Time calculation problem (URGENT>>>Project due) 4
Converting dd:hh:mm to [h]:mm not working. 3
Difference of Time 1
how do i combine a date cell and a time cell in excel? 3
Delete rows based on multiple criteria 6

Back
Top