HDTutorial
EN
How to Calculate Overtime Hours on a Time Card in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Calculate Overtime Hours on a Time Card in Excel

723,683 views November 1, 2011 10:10

Watch on YouTube
ChannelDanny Rocks

Description from the creator

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

About this tutorial

Danny Rocks published this 10:10 video tutorial on November 1, 2011. It has been watched 723,683 times on YouTube.

Category
Education
Duration
10:10
Published
November 1, 2011
Views
723,683
Likes
2,958

Tags

Share

This tutorial in other languages