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

#excel #developer