calculating time

G

Guest

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
 
B

Bob Phillips

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)
 
B

Bob Phillips

So what>

=B2-A2

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
tom ossieur said:
Problem is that date and time are in different columns

Bob Phillips said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 

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

Calculating time for 3rd shift 4
Calculate elapsed time excluding specific timeframe 10
I would like to take time from "A1" and add 14 hours to it. 1
lunch break!! well..how to figure 5
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculating the Count of Monthly Gains/Losses 3
Calculate the duration between the end time and start time of anot 4
Calculating turaround time using IF function 2

Top