calculating time
 

Hi,

given a departure and arrival date and time, how to calculate the travel
time (in hours)

A B C D
From To
10-Oct 00:05 12-Oct 14:13

Cell E should give the total amount of hours.

Many thanks!

tom

calculating time
 

Subtract the earlier from the later and format the result cell as [h]:mm or
just [h]

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"tom ossieur" wrote in message
...
Hi,

given a departure and arrival date and time, how to calculate the travel
time (in hours)

A B C D
From To
10-Oct 00:05 12-Oct 14:13

Cell E should give the total amount of hours.

Many thanks!

tom

calculating time
 

Problem is that date and time are in different columns

"Bob Phillips" wrote:

Subtract the earlier from the later and format the result cell as [h]:mm or
just [h]

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"tom ossieur" wrote in message
...
Hi,

given a departure and arrival date and time, how to calculate the travel
time (in hours)

A B C D
From To
10-Oct 00:05 12-Oct 14:13

Cell E should give the total amount of hours.

Many thanks!

tom

calculating time
 

So what

=B2-A2

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"tom ossieur" wrote in message
...
Problem is that date and time are in different columns

"Bob Phillips" wrote:

Subtract the earlier from the later and format the result cell as [h]:mm
or
just [h]

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"tom ossieur" wrote in message
...
Hi,

given a departure and arrival date and time, how to calculate the
travel
time (in hours)

A B C D
From To
10-Oct 00:05 12-Oct 14:13

Cell E should give the total amount of hours.

Many thanks!

tom