Calculate the difference in date/time formatted cells

  • Thread starter Thread starter Longhorn1972
  • Start date Start date
L

Longhorn1972

I need to know how to find the difference in time in two cells with a
date/time format of 05/01 04:30
 
Hi,

With this in A1 and b1

15/05/2010 10:00 16/05/2010 11:30

formula

=B1-A1

Format the formula cell as dd hh:mm
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Just subtract the two cells and format the formula cell as custom [h]: mm

=A2-A1

Regards,
Per
 
Yes, absolutely correct David. I had this mindset of 1 day and a few hours.
Thanks for the correction.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top