Struggling to calculate work hours for overnight shifts in Excel? In this tutorial from Tryit Learnit 365, you’ll learn how to add time in Excel, including how to handle shifts that span past midnight using simple formulas and formatting tricks 🕘💼.

📌 What you’ll learn:

• Subtracting start time from end time using basic formulas

• Using the MOD function to fix time errors that cross midnight 🌒

• Setting correct formats like [h]:mm to show total hours

• How to auto-fill time formulas down a column

• Fixing common Excel issues like ##### and incorrect totals

✅ Works in Excel 2013, Excel 2016, Excel 2019, and Microsoft 365.
💬 Drop your questions or future video suggestions in the comments!

📌 Subscribe to Tryit Learnit 365 for more Excel and Microsoft 365 tutorials.