How to Format a Row Based on the Value of a Cell in Excel 2007 ... the difference between two dates. You can use a simple subtraction operation such as "=B2-A2" to calculate the amount of days ...

You can use the DATEDIF function or the NETWORKDAYS function to calculate date duration in Excel. The DATEDIF function calculates the difference between two dates in calendar units (days ...

An Excel spreadsheet ... function then calculate the hour difference using the two MOD functions. Right-click where you entered your formula, which now has a strange-looking date in it.