How to Calculate Hours Worked with Excel Power Query (& Properly Sum time)

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...

Working with time in Excel or to calculate Hours Worked especially when they go past midnight can get tricky in Excel. Forget about using complex Excel formulas! In this video I'll show you how you can use Excel Power Query and its very helpful time transformation features.

⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/calculate-t...

Working with time has never been easier! With just a click of a few buttons you can:
Calculate the difference between two times
How to sum time in Excel
Subtract time
Calculate hours worked for any shift
Round up to the hour
Get the hour, minute or second portion of time

🎓 Get access to the complete Excel Power Query Course: https://www.xelplus.com/course/excel-...

Link to Excel Power Query playlist:    • Excel Power Query (Get & Transform)  

★ My Online Excel Courses ► https://www.xelplus.com/courses/

00:00 Working with Time in Excel
01:49 Time Transformation in Excel Power Query
04:59 Add Weekday in Excel Power Query
06:42 Aggregating Hours Worked with Excel Group By

➡️ Join this channel to get access to perks:    / @leilagharani  

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

🚩Let’s connect on social:
Instagram:   / lgharani  
LinkedIn:   / xelplus  

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel #powerquery