Difference between two dates and hours

Hi,

According to your post, my understanding is that you wanted to calculate the difference between two times.

We can use the following formula to achieve it.

=TEXT(Date2-Date1,"hh:mm")

http://ift.tt/1ofHK4A

Thanks & Regards,

Jason

---

Jason Guo

TechNet Community Support