| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ugh..another time and date problem...HELP | Excel Worksheet Functions | |||
| convert interval to various separate date , time, hr, minutes | Excel Worksheet Functions | |||
| Login Logout Date Problem | Excel Worksheet Functions | |||
| date and time | New Users to Excel | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
Linear Mode
