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.
 
You must log in or register to reply here.

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

Conditional Formatting - Dates 2
Subtract times? 2
subtracting date and time to find the difference between the two 4
Help with date difference 1
Calculating time differences across two (or more) dates 1
If statement with dates 0
Date / Time problem 4
Date Difference in Complete Tax Years 1

Back
Top