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

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-time-file

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-power-query/

Link to Excel Power Query playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-

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: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

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: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/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