Total time duration formula help;

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am trying to make a formula to figure out the difference
or duration between 2 time/date cells. For example; you
leave from point A at 5am and arrive at point B at 7:30pm,
I would like it to give me the total amount of time it
took. (7:30pm - 5am)?
Any suggesions are greatly appreciated on how to do this.
Thank you!

Paul
 
Subtract the earlier from the later and format the result cell as time,
hh:mm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top