Tech

Use Excel to calculate the hours labored for any shift

With Microsoft Excel, you possibly can create a worksheet that figures the hours labored for any shift. Observe these step-by-step directions.

Video: The way to calculate hours labored in any shift utilizing Excel
There is a trick to accurately calculating an worker’s hours labored utilizing Microsoft Excel. This is how one can do it.

To calculate in Excel what number of hours somebody has labored, you possibly can usually subtract the beginning time from the tip time to get the distinction. But when the work shift spans midday or midnight, easy subtraction will not reduce it.

Nonetheless, you possibly can simply create a worksheet that accurately figures the hours labored for any shift.

SEE: Value comparability calculator: G Suite vs. Workplace 365 (Tech Professional Analysis)

Observe these steps:

In A1, enter Time In. In B1, enter Time Out. In C1, enter Hours Labored. Choose A2 and B2, and press [Ctrl]1 to open the Format Cells dialog field. On the Quantity tab, choose Time from the Class record field, select 1:30 PM from the Sort record field, and click on OK. Proper-click C2, and choose Format Cells. On the Quantity tab, choose Time from the Class record field, select 13:30 from the Sort record field, and click on OK. In C2, enter the next system:

=IF(B2

Should you enter 11:00 PM because the Time In and enter 7:00 AM because the Time Out, Excel will show eight, the right variety of hours labored.

A bonus Microsoft Excel tip

From the article 10 issues you must by no means do in Excel by Susan Harkins:

Depend on a number of hyperlinks: Hyperlinks between two workbooks are frequent and helpful. However a number of hyperlinks the place values in workbook1 rely on values in workbook2, which hyperlinks to workbook3, and so forth, are exhausting to handle and unstable. Customers overlook to shut information, and generally they even transfer them. Should you’re the one particular person working with these linked workbooks, you may not run into bother, but when different customers are reviewing and modifying them, you are asking for bother. Should you actually want that a lot linking, you may take into account a brand new design.

This bonus Excel tip can also be accessible within the free PDF 30 issues you must by no means do in Microsoft Workplace.

Editor’s be aware on March 11, 2019: This Excel article was first revealed in June 2005. Since then, we have now included a video tutorial, added a bonus tip, and up to date the associated sources.

Microsoft Weekly Publication

Be your organization’s Microsoft insider with the assistance of those Home windows and Workplace tutorials and our specialists’ analyses of Microsoft’s enterprise merchandise.
Delivered Mondays and Wednesdays

Enroll right now

Additionally see


Supply hyperlink

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Close
Close