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.

Press "Ctrl-V" to paste the start and end times for the first work day into these currently empty cells. Excel will automatically adjust the formula cell references for each day of the work week.

From Formulas > Function, select Date & Time, then select DAYS from the drop list. In the End_Date field box, point to A4, and in the Start_Date field box, point to A5. Or just move your cursor to ...

Excel makes quick work of tracking time. With the right formatting, formula and dependent time values, you can return the hours worked for a given day, week, month and so on. If all you’re doing ...

Competitive Excel went viral on ESPN last year. This year, it’s back as part of the network’s “The Ocho” event, and the battle will be bigger than ever.