View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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!