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.

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

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.