combine date one column, with time another column into third?

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

Guest

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
 
You must log in or register to reply here.

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

How to combine two columns into a new column 2
Combine as Date 3
Excel Sumproduct 0
Excel Average dates help 0
combining data from multiple worksheets into one 6
Determining the Sunday date of the third "full" weekend of a month 25
using two cells 1 with total time n 1 with date how can i put the. 2
excel formula, counting with two columns 0

Back
Top