DATEDIF (), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.

In this tutorial, I’ll show you how to enter time values in Excel. Then, we’ll review three Microsoft Excel functions that will help you parse the hour, minute and second values from a ...