• Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to calculate working hours based on the timesheet in Excel

0 Comments

How to calculate working hours based on the timesheet in Excel: In a company, the accounting department is responsible for managing the working hours of all employees to calculate their salaries. Usually, the timesheet provides data for the time in and time out to calculate working hours. So, how can you get accurate and fast calculation results? Read the article below to learn how to calculate working hours in Excel (through functions and tricks).

For example, we have a timesheet as shown below. We need to calculate the daily working time for each person.

1. Calculate working hours by subtracting the time out from the time in

The simplest way to calculate working time on the timesheet is to subtract the time out from the time in. In cell D2, enter the following formula:
=C2-B2

Copy the formula for all remaining cells to get the results.

How to calculate working hours based on the timesheet in Excel

How to calculate working hours based on the timesheet in Excel

2. Calculate working time using functions

With this method, we need to use two functions: HOUR and MINUTE. The structure of the two functions is as follows:

a. HOUR function

Function syntax: =HOUR(serial_number)

Where: serial_number: Required argument, the time containing the hour you want to extract.

The HOUR function is used in Excel to return the value of the hour in the Excel cell. The hour value is returned as an integer from 0 (12:00 AM) to 23 (11:00 PM).

b. MINUTE function

Function syntax: =MINUTE(serial_number)

Where: serial_number: Required argument, the time containing the minute you want to extract.

The MINUTE function is used in Excel to return the value of the minute in the Excel cell. The minute value is returned as an integer from 0 to 59.

Applying the structure of the two functions above, we have the formula to calculate working time on the timesheet as follows:

=(HOUR(time out)*60-HOUR(time in)*60+MINUTE(time out)-MINUTE(time in))/60

In cell D2, enter the following formula:

=(HOUR(C2)*60-HOUR(B2)*60+MINUTE(C2)-MINUTE(B2))/60

Copy the formula for the cells below. Then, select all result cells, and choose the General format in the Number section.

How to calculate working hours based on the timesheet in Excel

How to calculate working hours based on the timesheet in Excel

The results of the working time for all employees will be as follows:

How to calculate working hours based on the timesheet in Excel

How to calculate working hours based on the timesheet in Excel

Therefore, the above article has guided you on how to calculate working time on the Excel timesheet. Hopefully, this article will be useful for you in your work. Wish you success!

7
59 Views
Using REPT function to repeat text or numbers in ExcelPrevUsing REPT function to repeat text or numbers in ExcelMarch 21, 2023
How to quickly fix Excel error prompting to save file with a different nameMarch 22, 2023How to quickly fix Excel error prompting to save file with a different nameNext

Leave a Reply Cancel reply

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

Recent Posts
  • Retrieve Data Based on Data Validation
    September 7, 2023
    Excel
  • How to Convert Multiple Rows to Columns and Rows in Excel?
    September 6, 2023
    Excel
  • VLOOKUP for Automatic Discount in Data Validation
    September 6, 2023
    Excel
  • How to Convert Text Dates to Dates in Excel?
    September 5, 2023
    Excel
Categories
  • Blog 80
  • Excel 754
  • Powerpoint 36
  • Software tricks/tips 128
  • Uncategorized 8
  • Word 109
Tags
the ISERROR
Top rated products
  • Windows 11 Pro Product Activation Key - Latest version 2021
    Rated 5.00 out of 5
    $11.00
  • AVG Internet Security 2021 10 Devices 1 Year Global AVG Internet Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $30.00
  • Kaspersky Total Security 2021 1 year 1 device key Global Kaspersky Total Security 2021 1 year 1 device key Global
    Rated 5.00 out of 5
    $27.00
  • Avast Ultimate Suite 2021 2 Years 10 Devices Global Avast Ultimate Suite 2021 2 Years 10 Devices Global
    Rated 5.00 out of 5
    $77.00
  • Buy Windows 11 Pro CD Key License
    Rated 5.00 out of 5
    $11.00
Products
  • Buy Office 2021 Professional Plus Key Global For 5 PC
    Rated 5.00 out of 5
    $45.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.83 out of 5
    $49.00
  • Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $15.00
  • Windows Server 2022 Standard Key Global
    Rated 4.47 out of 5
    $15.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $45.00

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.