how do I get the difference between two times in hours

G

Guest

I work with scheduling of ships. We are trying to monitor transit times that
span several days. What I am looking for is a function that will calculate
the number of hours and tenths of an hour between two dates/times.

For example, I have a ship that leaves Los Angeles on 6/12/2004 23:18 GMT,
and arrives in Honolulu on 6/17/2004 10:30 GMT. How do I get the number of
hours transit time between the two dates that is accurate to the 1/10th hour?
 
P

Peo Sjoblom

One way, startdate_time in A1, end in A2

=ROUND((A2-A1)*24,2)

format as general

Regards,

Peo Sjoblom
 
J

Jason Morin

=(B1-A1)*24

where B1 = arrival date/time and A1 is departure
date/time.

HTH
Jason
Atlanta, GA
 

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 difference between two times 2
Calculating Difference Between Two Times in General Format 4
Calculate the difference between two times - getting '#VALUE!' err 2
Need difference between two dates/times in hours 10
Calculate the difference between two times and show dd:hh:mm:ss 7
Diference between two hours in Minutes 3
how can we calculate the numbers of hours between two dates and 4
Difference between dates/times in Days & Hours 2

Top