A viewer asked me to show him how to calculate the number of Overtime Hours Worked and the Payment for those hours on a Time Card in Excel.

Hew was frustrated - along with most Excel users - because the formulas he used did not produce the results that he was expecting. Excel is VERY picky about the FORMATTING that must be supplied to the cells that calculate the differences in times and the totals for times that exceed 24 hours.

Watch, as I demonstrate how to work with Time Functions, Formulas and Formats in this lesson.

I invite you to visit my website - www.thecompanyrocks.com - to learn more about the resources and services that I offer.

Danny Rocks
The Company Rocks