Calculate Hours Worked Overnight in Excel - Tutorial

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.

*FYI:

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 😊

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

[Coquitlam]

Hello Acosta, thanks for this but I have a question

[anilrawat]

Thank you so much for this video to convert total hours to number

[daniel.shalome]

Thanks very helpful to track the amount of sleep im getting

[cattac]

If I work after midnight is 1.5 rate, start time 10pm, end time 5 am which formula for time calculation the best😮

[edwinotieno]

You are underrated . You deserve more subscribers and views. Very helpful clip. Thanks a lot

[cduanetech]

help please. .formula on computing hours work .. sample 3:00pm - 4:30 . equivalent hours is 1.5 ..tnx a lot

[TheModernGlitch]

Thanks so much for this video! I was really having trouble with this formula!

[_Aidelweiss_]

I been looking hours for this formula. thank you

[harrydoolabh]

Thank you you make it so simple and easy to understand

[rogerwillis]

I was wondering when you were going to add this info! Thanks!

[Hi-syly]

Hi
How to maintain same date after midnight ( do not change to next day after 12 am)

[anonymousperson]

Would this work if you start at 1 pm and finish at 2 pm the next day?

[italinashane]

Thanks I learned it in a matter of minutes. Great lesson.