Calculate Hours Worked Overnight in Excel - Tutorial
22.9 هزار بار بازدید -
5 سال پیش
-
Excel tutorial on how to
Excel tutorial on how to calculate hours worked overnight in Excel. Calculating the hours worked when you clock out the next day is a bit tricky. We'll go over a formula you can use to help you sum hours worked in a night shift.
It's important to note that Excel sees time as a decimal between 0 and .99, each number representing a fraction of a 24-hour period. So when you need to subtract PM from AM in Excel, the result is a negative number. And Excel does not process negative numbers as time and so displays an error.
In this tutorial, we follow an example of tracking hours worked. We go over a formula you can use to calculate hours worked in an overnight shift, how to convert the hours to a regular number, and then use that to calculate pay in Excel based on the hours worked.
As promised, if you want to learn more about the math behind MOD, take a look at this explanation from Khan Academy: http://bit.ly/2SynwoP
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
It's important to note that Excel sees time as a decimal between 0 and .99, each number representing a fraction of a 24-hour period. So when you need to subtract PM from AM in Excel, the result is a negative number. And Excel does not process negative numbers as time and so displays an error.
In this tutorial, we follow an example of tracking hours worked. We go over a formula you can use to calculate hours worked in an overnight shift, how to convert the hours to a regular number, and then use that to calculate pay in Excel based on the hours worked.
As promised, if you want to learn more about the math behind MOD, take a look at this explanation from Khan Academy: http://bit.ly/2SynwoP
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: https://yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: https://yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: https://yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: https://yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
5 سال پیش
در تاریخ 1398/05/02 منتشر شده
است.
22,969
بـار بازدید شده