Grab the file I used in the video from here 👉 pages.xelplus.com/calculate-time-file

Mam, you're a blessing to the Excel community! 👌✨

Hey thanks for this tutorial. Using this video as a guide let me figure production per hour per day for each person on my team. Total game changer, I’m excited to apply this to other reports.

Excellent work and explanation Leila! I would appreciate more Power Query videos because they help a lot with data processing. Thank you very much!!

Hi Leila, thanks for the excellent demo and lesson on manipulating time with Power Query. Your thorough and complete explanations are always appreciated. Thumbs up!

@LeilaGharani

4 жыл бұрын

Glad you enjoyed it, Wayne!

Thank you very much Leila for this wonderful tutorial. I have been trying to find a way to properly calculate the duration in Power BI and this helped me a lot...

Great collection! Thank you for the videos.

Essential topic ,very nicely explained and simplified. Thanks a lot for sharing.

I wish i had known about this 8-9 years ago!!! Excellent video, Leila!!

Alas! If only I would have known this on "Time", when I needed it two years before! I struggled a lot that time with formulas, formatting and macros to somehow solve it! So once again Leila, thanks for showing a simple yet amazing way of handling time data! You are Super! :-)

@LeilaGharani

4 жыл бұрын

I've been there too :) Hope it will come in handy in the future.

youre still the best!!! no one can beat you girl!!!

Excellent. I’m going to investigate using this with time in of a query to time out of a query, taking into account working hours, weekends, and holidays

Extremely helpful video as always! Thank you so much for what you do and your style of teaching. I have learned so much and referred many of my friends and coworkers to your video over the years :)

@LeilaGharani

3 жыл бұрын

Great to hear! Thanks for your support.

Thanks , I was searching for this all over for a long time. Thank you. Please also we need the transformation of time to power BI

Thanks Leila for sharing this. This is surely going to help lot of employers and freelancers who regularly track time in excel.

@LeilaGharani

4 жыл бұрын

I hope it'll be helpful.

Very useful Video. Im just learning Power Query and creating good looking Dashboards in Excel. Your videos have really taken me further here.

Been working on this for so long, this is soo much easier than all the other methods. THANK YOU x

@LeilaGharani

4 жыл бұрын

You're so welcome!

Thanks Leila for the work. wish you all the best

Always useful tutorials. Thank you.

I like the power query, good, Thank you Leila!

Hi Leila, that's an awesome solution from you as usual, great job! I have learned a lot from your videos, wondering if you can demonstrate how we can prepare a FIFO based stock aging calculation model using Power Query. I can provide a sample I have developed using formulas and am sure it can be simplified through Power Query. Thanks

Wow so it remembers that we've merged the two columns we deleted for Work Day and repeats the process in the background! This is amazing 😍

@LeilaGharani

4 жыл бұрын

Yes, exactly! PQ is great!

Wow.....this is so amazing. I don't have to worry about formulas to calculate datetimes. PQ is a game changer. Thanks for sharing Leila

@LeilaGharani

4 жыл бұрын

It really is :)

Love your thumbnail. The Back to the future movies are flippin awesome. By the way thanks for these videos. Very invaluable source of information regarding spreadsheets.

Thanks Leila, this is very insightful

Yes! Excellent lesson.

OMG you are the Queen ! Thanks !

@StaticBlaster

2 жыл бұрын

Yes! Yes she is. The queen of knowledge!

Thanks Leila.... I can see these techniques being very helpful in many business situations. Great explanation.

@LeilaGharani

4 жыл бұрын

I hope it will come in handy, Matt.

Thank you Leila, excellent as always. I do not know how, but your videos come always at the best time! :)

@LeilaGharani

4 жыл бұрын

That's great to hear Gabriella :)

Thank you so much! I did not know it was this easy! I've been trying to do DAX formulas that were not working right.

Find it very useful. Nice to have a spreadsheet to practice. Took me about 20min to do everything as in the video (translating the buttons to portuguese in my head hehe). Thank you!

@LeilaGharani

4 жыл бұрын

Excellent!

You're the best ever

Thanks Lelia. Very helpful as always

Great tip! Thanks

Perfect ... Thanks Leila

Very nice presentation Leila. I love this

I straight away hit LIKE. Lovely video and Lovely Leila :)

Thanks for this Leila

Excelente vídeo. Parabéns!

wonderful. thank you very much!

Thank you. Very nice explanation.

Informative, Thanks Leila 🙂

Goodness...You really are good at this...Thanks

Many thanks 🥰

Thank you! It`s awesome tutorial

very great video ♥ many thanks

How can someone speak so beautifully!!!!!

Superb information about date and time data

Great session! Thank you very much.

@LeilaGharani

4 жыл бұрын

Glad you enjoyed it!

I love powerquery!

awesome video. thanks for sharing.

Thank you Leila

It's Awesome Tricks, Thanks for sharing.

Hi , this one is really good.... I admire your teaching skill's a lot . Keep doing the Good work..

@LeilaGharani

4 жыл бұрын

Thank you, I will

THANK YOU SO MUCH FOR THIS TUTORIAL!!!!!!!!!!!!!! YOU SAVED ME

@LeilaGharani

Жыл бұрын

Glad it helped!

Hey Leila you are awesome. Thanks for sharing great stuff..

@LeilaGharani

4 жыл бұрын

Thanks for watching!

Great thanks! Saving me for the second time today XD

Another wonderful video Leila.. thank you..

@LeilaGharani

4 жыл бұрын

Thank you too!

Great job Leila!

@LeilaGharani

4 жыл бұрын

Thanks Chris 😊

Excellent video as always Leila! A quick question: in the last table showing total hours worked by each person, I would like to show it in "days : hours : minutes : seconds". How would I do that? Thank you very much for all your videos.

Thanks!

hello, je suis heureux de vous comprendre et de vous écouté helas y a plus de traduction automatique sur certaine video... MERCI A VOUS POUR VOS SUPER TUTO

Great work

Hello Leila you are a life saver 😘😘😘.

@LeilaGharani

Жыл бұрын

Happy to help!

This was so, so helpful

@LeilaGharani

8 ай бұрын

Happy to hear that!

Previously i was subtracting end to start time and then converting to minutes n second using text fn and pasting special to values or multiplying hours to 1440 to get numbers in minutes. Well its way to easy in power query as compared to earlier way of calculations.

you are the best

Wow. Thanks

This is a useful one Happy Thursday your highness 🙏

@LeilaGharani

4 жыл бұрын

Glad to hear it! Happy Thursday to you too :)

thanks for the video, very helpful, i was wondering how to do the basic time, undertime and overtime in this video

Perfect!

Hi Leila!I Have Set This Same Scenario Up For Project Managers In Work Using Power Query...Thank You For A Really Enjoyable Tutorial :)

@LeilaGharani

4 жыл бұрын

My pleasure Darryl!

Thanks 🙏🙏

Wow so simple

Amazing ❤

Happy Thursday Leila. Thanks...

@LeilaGharani

4 жыл бұрын

Same to you! Thank you :)

Coooooool👍

Great video. Could apply this to tracking case work if you could find the duration between 2 dates/time but exclude weekends and non working hours

Very Wonderful 🤩

Muito Muito Bom

This is great 👌 Thanks 😊

@LeilaGharani

4 жыл бұрын

You're welcome 😊

thanks.

Beauty with Brain, rare combination

Super trick

amazing

Mam, Thank you so much for the video.

@LeilaGharani

4 жыл бұрын

Most welcome 😊

Thank you!! This is very powerful especially for project based work or for manufacturing. Question on this however... how do I factor in lunch, dinner and midnight break times of let us say 1 hour each?

Hi Leila, thanks for the tutorial, Is it possible for you to show an example of how to calculate % on on time/ late performance logistics based on quantity in Power Query example ? Thanks

Genial..

It's a great idea to use Power Query in time calculations. You can also get an age by simply using User Interface

@LeilaGharani

4 жыл бұрын

👍

Hi Leila very useful video and as always, carefully explained. I would like to ask you if it is possible to implement this technique by enhancing the hours worked with different values ​​depending on whether they were worked after 8 hours (overtime e.g. + 25% for the 2 hours after 8 and + 50% beyond, i.e. 10 hours worked = 2 hours + 25%, 12 hours worked = 2 hours + 25% and 2 hours + 50%) also work on Saturdays and Sundays should have an increase of + 75%, at least this is what happens in Italy, thanks!

Nice use and despite the lazy workers (rounding up to impress their manager) will make me use PowerQuery a lot more. It is just hard as a Non-American to read these weird time formats. As a database engineer I just wish more people use (and present) ISO 8601 standards (which coincidentally makes imports from Excel into a database just so much smoother)

Thanks Leila, I'd like to know if power query could calculate working days, considering holy days and Saturday and sundays

Thank you Leila! Is there a way to do SUMIFS and AVERAGEIFS with PQ? If there is could you make a video about those?

Hello Mam, thanks for the tutorial. It will be helpful if similar logic can be arrived using formula. Because power query needs a refresh every time. Or is there a way to refresh the query automatically based on a scheduled time? We use excel for SLA calculation of tickets. In such cases, power query needs a refresh after each update. So, could you please make a tutorial based on formula in future.

Wow!

Oh Today is on Thursday.... 😜😜 I love your work Mom

@LeilaGharani

4 жыл бұрын

😊 thank you

It's about time somebody explained this. Now excuse me while I calculate how long I've been waiting.

@LeilaGharani

4 жыл бұрын

No, you can't do that. It's about hours WORKED 😁

Really useful stuff no more formulas

@LeilaGharani

4 жыл бұрын

Glad it was helpful!

I lrean a new leason Thank you 😍