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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

psalyers - 23 Aug 2005 19:27 GMT

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!

Reply to this Message

Biff - 23 Aug 2005 19:34 GMT

Hi!

Just add the 2 cells together:

A1 = 8/23/2005
B1 = 1:10 PM

=A1+B1

Biff

>I need to be able to calculate the number of hours from beginning of
> procedure to end of procedure.
[quoted text clipped - 9 lines]
>
> Any help would be appreciated!

Reply to this Message

sirknightly - 23 Aug 2005 20:05 GMT

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

psalyers Wrote:

> I need to be able to calculate the number of hours from beginning of
> procedure to end of procedure.
[quoted text clipped - 12 lines]
>
> Any help would be appreciated!

Signature

sirknightly

Reply to this Message