How do I calculate the difference between 2 times in Excel 2010 in - Microsoft Community
Times are stored by Excel as fractions of a 24-hour day. So to get the difference between two times as decimal hours, you just need: =(later time - earlier time)*24 and format as a number with 2 dp. Dates are stored by Excel as the number of elapsed days ...