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:
► youtube.com/watch?v=hhJ5T8wqRGk&list=PLAE-5…

Excel Alignment Formatting
► youtube.com/watch?v=hRlrj_np0Tw&list=PLAE-5…

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

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

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron
YouTube ► youtube.com/@ExcelTutorialsEasyClickAcademy/join

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

⏱️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
► youtube.com/c/ExcelTutorialsByEasyClickAcademy?…

Got Microsoft Office 365? Get it here
► easyclickacademy.com/buy-microsoft-office/?utm_…

Transcription How to Calculate Hours Worked in Excel (Midnight Span) here
► easyclickacademy.com/How-to-Calculate-Hours-Wor…

Connect:
LinkedIn ► linkedin.com/company/easyclickacademy
Facebook ► facebook.com/EasyClickAcademy

Screen Recorder & Video Editor:
Camtasia ► techsmith.pxf.io/c/1266206/347799/5161?u=https%…

Voice over artist ► seanantonyvo.com

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy