How to Calculate Time Cards in Excel. If you pay employees an hourly wage and use time cards to track their weekly work time, you can use Microsoft Excel to calculate work totals, simplifying your ...

You can use Excel to log the time that employees clock in and out of work using Excel. You can either have employees directly add hours in Excel to a spreadsheet as they clock in and out or use ...

Fortunately, Excel offers a built-in function, DATEDIF, which makes it easy to calculate elapsed calendar time.

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.