| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
join date & time & add hours
I have a column with a date (which is an actual date) and a column with a
time (which is a text value). I wish to combine these as a signle date time value and then add 14 hrs to this. If my date is in A1 and my time is in B2 then what formula should I use in C1? Bruce |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add 24 hours to a date and time value formated cell? | Excel Discussion (Misc queries) | |||
| How do I join a date and time that are in separate columns? | Excel Discussion (Misc queries) | |||
| Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
| Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
