Thank you

Now i am gonna suscribe your channell...looks great

Thank you very much sir...❤❤❤❤❤

If I worked less as a regular day, like 6 hrs? Which formula is?

Thank you sir

thanks danny

Thank you so much! it was very straightforward and helpful! :)

why do I end up 2 female columns and 1 male column in my table

You are an amazing teacher! I have looked at so many videos on VLOOKUP and yours was the only one that made sense and I understood! Thank you!!!

your voice is very conducive to helping people learn

Thku Sir for information 💐💐💐

Thanks Sir

Mr danny can i ask question

THIS IS 11 MINUTES OF A DUDE YAPPING AND NOT ACTUALLY SHOWING ANYTHING AT ALL. DON'T WASTE YOUR TIME!

Thank you for your help. Saved me a ton of time!!

Why is the group not working

But there is a problem when we must reference another sheet in a secondary one. And if it has a bookmark link it gets more confusing. Don't you think so?

Thank you! I needed this for a statistics course. :)

Thanks for sharing

Thank you so much . Been struggling with my age categorizing for a week. This really helped alot <3

Dear sir. May I mail you PLS...? 🙏🏽

its helpful but for my file "cannot group the selection " any help please ?????

you're a lifesaver!

How do we get the formula to subtract 30 minutes for lunch if over 6 hours are worked?

Great tutorial. Is there anyway to randomize the intervals within the set time?

Your video is the best timecard version on YT, thank you for being so thorough and an excellent instructor!

Thanks a lot. I had to fill 58 cells and it was a pain doing it manually. Now I know better!

How do you update a cell in target sheet when the cell in another sheet is updated? Thank you for this concise and clear tip. Made VBA less enigmatic.

Thanks for making this man, the number of these videos that are generally by Indians with bad microphones and bad English made this very difficult 😂

You never told us you pull up Function Arguments and I cannot find it in Excel!

Nice Work I just subscribe to your channel, where can I download your spreadsheet.

Was really helpful. Especially calculating the final time

I am having a hard time, my standard week hours is 50, and when i enter the custom format [h]:mm and the formula =time(50,0,0) it gives me 2:00. how can i get this to say 50 hours is my standard work week

thank you so much 15 year old video

I'm trying to create a time series that starts at minus 20 minutes and each descending cell is ahead by 30 seconds 😅😅😅 so -0:20:00, -0:19:30, -0:19:00 etc until like. +1:19:30. This has been such a headache!! I need to do increments by seconds, but starting "negative time" ="Cell"+30*(1/24/60/60) did not work for me, how is the first cell formatted?

Thank you Sir. This was helpful ❤

Why not allow to use pivot table?

The daily overtime calculation was really helpful. How do we also add the weekly overtime for over 40 hours/week?

Very usefull thank u

Watched this in 2024 and it is a big help for me. Thanks a lot for this very informative video.

Could you share the data

Thank you!

NO, is there a way to fill cells when I write "11:15 to 11:45" and then "11:45 to 12:15" and so on????

THANKS

Thanks alot

Thank you from the bottom of my heart for all the invaluable lessons you shared on Excel. Your channel was my go-to guide for school projects, and your teaching style made complex concepts so much easier to understand. It's with a heavy heart that I learned of your passing. You were not just a teacher on KZbin, but a mentor who made a lasting impact on my learning experience. Your legacy will live on through the knowledge you shared. Rest in peace, and thank you for everything. 💔🙏

Just what I needed, thanks

Great Job - thank you for explaining this :-)

Great video. I would like to throw a wrinkle in there. For reasons too long to explain here I need to convert the OT hours to regular hours and then calculate pay. Excel is giving me problems when doing this. For example a worker worked 65.hours at 9.25 and 7 hours of OT at 12.38 so his pay should be 687.91. NOW, if I convert the OT hours (7*1.5=10.5) and I add them to the regular hours 65 + 10.5 = 75.5 * 9.25 I get 698.38

Thanks