Formulas

S

Stephanie

I am trying (with no luck) to create a formula that will allow me to
calculate the hour difference between different days. For example: 1pm
yesturday vs 1pm today would equal 24hrs. Does anyone know how to do this.
Please help I need it for work.
 
D

Domenic

Include the date along with the time. For example, if A1 contains...

2/13/06 1:00 PM

....and B1 contains...

2/14/06 1:00 PM

....the difference in time is...

=(B1-A1)*24

....which returns 24.

Hope this helps!
 

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

Start Date Not Calculating Correctly? 0
Difference in Time hour what formula to use in excel? 4
Using <= in countifs statement 1
Copy addition formula of non-consecutive horizontal cells 2
how to get Resource availability by hour - MS project 2007 2
Office365 Family + TXT or MX Domain 0
Add Time Q 4
Word 2016 - Difficulties Learning Style Creation/Application 0

Top