Calculating time differences across two (or more) dates

  • Thread starter Thread starter jonewer
  • Start date Start date
J

jonewer

Hello all,

What I'm trying to do is to calculate the time difference between tw
date/times.

eg I have

01/05/2006 18:00 in A1 and 02/05/2006 05:30 in B2

How can I calculate the number of hours and minutes that have elapse
between A1 and B2?

Currentley I have the cells in dd/mm/yyy hh:mm:ss format but can chang
this if needs must.....

Thanks for yer time
 
Back
Top