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! |
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! |
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:
|
All times are GMT +1. The time now is 03:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com