How To Count Or Calculate Hours Worked In Excel смотреть онлайн

How to Count or Calculate Hours Worked in Excel
In this quick excel tutorial I’ll be teaching how you can calculate hours worked in excel and when you have done it you’ll be able to calculate total hours worked in a month in excel. We are going to use formula to create this excel time-sheet calculator. Let’s learn how you can do it.

Step 1: Create Log in time and log out time column
Step 2: Now simply use this formula. Log In time cell - Log Out Like this =A1-B1
Step 3: Right Click on the Cell and Click on Format Cells
Step 4: Select Time
Step 5: Select the time with 24hours format. Or 13.30 from the list
Step 6: Drag an autofill formula and done.
You’ve just calculated hours worked in you excel template. You can use this technique to calculate total hours worked in a week in excel.

Checkout this video
Excel formula to calculate hours worked minus lunch: https://youtu.be/S-jEciSKxFA

#TimeSheet #HR
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial