I am trying to extract a time difference (in minutes) between 2 events.

These times are presently recorded in 4 columns, both events respectively in
types dd/mm/yyyy and hh:mm. I am trying to fuse this data into two columns of
type dd/mm/yyyy hh:mm such that I may use a simple substraction as shown in
the help file "Calculate the difference between two times".

I tried using the Concatenate function, but I've remained unsuccessful. Any
tips?

Use

=(C1+D1)-(A1+B1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"pascal" wrote in message
...
I am trying to extract a time difference (in minutes) between 2 events.

These times are presently recorded in 4 columns, both events respectively
in
types dd/mm/yyyy and hh:mm. I am trying to fuse this data into two columns
of
type dd/mm/yyyy hh:mm such that I may use a simple substraction as shown
in
the help file "Calculate the difference between two times".

I tried using the Concatenate function, but I've remained unsuccessful.
Any
tips?

problem solved ... when columns the three columns are properly typed, a
simple addition of dd/mm/yyyy and hh:mm suffices to make a dd/mm/yyyy hh:mm

My error lay elsewhere in previous programming.


"pascal" wrote:

I am trying to extract a time difference (in minutes) between 2 events.

These times are presently recorded in 4 columns, both events respectively in
types dd/mm/yyyy and hh:mm. I am trying to fuse this data into two columns of
type dd/mm/yyyy hh:mm such that I may use a simple substraction as shown in
the help file "Calculate the difference between two times".

I tried using the Concatenate function, but I've remained unsuccessful. Any
tips?