How to Calculate Hours Worked in Excel (Midnight Span)

We’ll carry on with the tutorial on how to calculate hours worked after a night shift. There’s a specific formula to total hours worked past midnight in Excel, but after watching this video, it’ll be a piece of cake!

In the last video tutorial, we had a look at how to calculate hours worked if the ‘Start Work’ and ‘End Work’ times are within the same day. We also calculated working time for each day, from Monday to Friday. The problem is, that this usual way of calculating hours will not work for you if the working time spans midnight, which is the case of Friday.

On Friday, work started at seven o’clock in the evening and finished the next day, at six o’clock in the morning. Since the working time spanned midnight, which means the employee didn’t finish work on the same day, we need to use the function IF to calculate the hours correctly.

Let’s do this together!

Watch next video tutorial:

Time Calculation In Excel:
► https://www.youtube.com/watch?v=hhJ5T8wqRGk&list=PLAE-5Y383vihGrGKitq9rbNg88-qecNTW

Excel Alignment Formatting
► https://www.youtube.com/watch?v=hRlrj_np0Tw&list=PLAE-5Y383vihs9djAQs14_cruQF64G_TX

How to Use IF Function in Excel (Step by Step)
► https://youtu.be/6YxhhuLOCcg
================

---⏱️Timestamps⏱️---
0:00 How to Calculate Hours Worked in Excel (Midnight Span)
1:11 How to Use If Function in Excel

================

Subscribe and watch more videos that help you use Microsoft Excel quick and easy
► https://www.youtube.com/c/ExcelTutorialsByEasyClickAcademy?sub_confirmation=1

Got Microsoft Office 365? Get it here
► https://www.easyclickacademy.com/buy-microsoft-office/?utm_campaign=How%20to%20Calculate%20Hours%20Worked%20in%20Excel%20(Midnight%20Span)&utm_medium=YouTube&utm_source=Popis

Transcription How to Calculate Hours Worked in Excel (Midnight Span) here
► https://www.easyclickacademy.com/How-to-Calculate-Hours-Worked-in-Excel-Midnight-Span?utm_campaign=How%20to%20Calculate%20Hours%20Worked%20in%20Excel%20(Midnight%20Span)&utm_medium=YouTube&utm_source=Popis

Become a Patron:
Do you find our tutorials useful? Chip in to keep us going. You can make a one-off donation with PayPal or support us regularly on Patreon. Thank you!
PayPal ► https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=7YLYA97RVPQYS&source=url
Patreon ► https://www.patreon.com/easyclickacademy

Connect:
LinkedIn ► https://www.linkedin.com/company/easyclickacademy
Facebook ► https://www.facebook.com/EasyClick-Academy-298349384414280
Twitter ► https://twitter.com/EasyClickAcad
Instagram ► https://www.instagram.com/easyclick_academy/

Voice over artist ► https://seanantonyvo.com

#ExcelQuickAndEasy #EasyClickAcademy

Видео How to Calculate Hours Worked in Excel (Midnight Span) канала Excel Tutorials by EasyClick Academy