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

August 20, 2020 Excel Power Query (Get & Transform)Show more

Check Out the Complete Excel Power Query Course: https://www.xelplus.com/course/excel-power-query/

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. 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

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/power-query-time-calculations

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

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

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

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Time Stamps
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

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

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!

#MsExcel #Excel #LeilaGharani #powerquery