Home |
Search |
Today's Posts |
#1
|
|||
|
|||
combine date one column, with time another column into third?
I need to be able to calculate the number of hours from beginning of
procedure to end of procedure. I download from another system which unfortunately puts the start date in one column and the time in another. I currently retype the date/time into a third column to use for calculations. To save re-typing and reduce potential errors in manually copying, I would like to be able to use a formula to take the date from one column and the time from another and place it in a third. Any help would be appreciated! |
#2
|
|||
|
|||
Hi!
Just add the 2 cells together: A1 = 8/23/2005 B1 = 1:10 PM =A1+B1 Biff "psalyers" wrote in message ... I need to be able to calculate the number of hours from beginning of procedure to end of procedure. I download from another system which unfortunately puts the start date in one column and the time in another. I currently retype the date/time into a third column to use for calculations. To save re-typing and reduce potential errors in manually copying, I would like to be able to use a formula to take the date from one column and the time from another and place it in a third. Any help would be appreciated! |
#3
|
|||
|
|||
Psalyers,
If Date is in Column A and Time is in Column B, use this formula in Column C (or wherever): =A1+TIME(HOUR(B1),MINUTE(B1),SECOND(B1)) Knightly Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Value between 2 dates | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) |