Video

How do I Insert 3rd sheet from another exel document ?

Great Video. Do you have a video for working Overtime as well to be calculated into Total Paid Hours for the Day?

You need to slow down in order to TRAIN excel beginners, I didn’t like it.

Hi thanks for this. I have done all this but I have a unpaid 45min break how do I put this in ?

Thank you so much for sharing this sir! Really helpful for me as a newbie in Excel. Explain well and easy to follow👍🏻👍🏻 double thumbs up for you sir

This is exactly what I need thank you.

Hi how to make formula if work start same day am or pm and finish work next day am or pm.

FORMULA ISSUE I'm adding a 3rd IN & OUT columns (F,G) to an existing sheet that had 2IN & OUT columns (B, C,D,E). The original formula for regular hours was: =IF((((C7-B7)+(E7-D7))*24)>8,8,((C7-B7)+(E7-D7))*24). I changed it to: =IF((((C7-B7)+(E7-D7)+(G7-F7))*24)>8,8,((C7-B7)+(E7-D7)+(G7-F7))*24) . I've tested it and it works. I can not get the overtime formula to work. The original was: =IF(((C7-B7)+(E7-D7))*24>8,((C7-B7)+(E7-D7))*24-8,0) . I changed it to: =IF(((C7-B7)+(E7-D7)+(G7-F7)))*24>8,((C7-B7)+(E7-D7)+(G7-F7)))*24-8,0)) . HOW DO i FIX THIS??

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

I worked time in 7pm and time out 12am, it gives me -18, help what do I do

You talk waaaay too much

Woww thank you, it helped me in 2024. Great job.

how did you put back the line column on the header?

I am trying to total hours work Mon-Fri > formula nothing working >just not working => must be me! Help if can // up to 6:49 on video my hours are Mon 8.00 Tues 7.15 Wed 8.00 Thu 8.00 Fri 9.00... these are electronically sent to the bookkeeper each week.

I used this video to create a time clock tracker to manage attendance. The problem I came across is when I deleted the time in and time out for a new week, the total hours worked field populates "-0.50". this is a problem for me because if someone takes a day off during the week, that days hours will be negative when it should be zero. Their total hours for the week will also include this negative. What format needs to be inputted to removed the negative if no value is there?

Amazing!

Total Hours worked formula is being funny with me even when I *24 I am in the UK and use the 24 hour time frame would this impact it at all?

Hi! Fist thanks for the great video I followed the steps but it keeps giving my negative value in worked hours because i work night shift, how to fix that? Thx

i cant do the 8:18 why is that im hitting F4 it dose not work

This was an awesome tutorial thank you so much my company hasnt set up a way for me to track my time yet and this came in sooooo handy thank u

I could not work out how to lock the formula. F4 DIDN'T work, I needed to do it manually. and my gross pay sum isn't working either. But otherwise it's really good. thank you

your going so quick its impossible to understand what your doing when we've never done this before

How do you do another column where lunch break is deducted.

I have a question. Would this be feasible for my Jr’s & Sr’s in High School so we can keep up with their time?

If the + at the bottom of the tabs is greyed out - How do you get active again

What if you clock in at 6:15 and clock out at 4:23

Super helpful, thank you!

Wowee this is very helpful thank you!

Absolutely the best. Can you do one for Time difference.

Too fast😕. Very hard follow.😮

Wonderful. Thank you!

You didn't answer the question. How do you insert a new sheet? There is no plus sign to add sheets at the bottom of a new workbook

is there a way to get a total sum of the D colum at the bottom? (Total noob here) Thanks for a good vid.

This perfect thank you

Thank you very much

Haven't used Xcel since high school, this really helped refresh the memory. Thanks a lot!

Can this be used for employees who are on salary as opposed to hourly? Or does this strictly just apply to those who are hourly?

Templates for both are not available.

Nice

very helpful as i learning a new job. excel is going to be my best friend for the foreseeable future

Realy nice and super

What about meal break?

Trying to learn it from my phone maybe if you could explain it from an android

Hi I need help I am doing night shift and I work from 8 pm to morning 9 am That's 13 hours. But when I enter my time in time sheet instead 13 hours it minus the hours it shows 11 hours . Can u explain please

the Dad jokes gave me cancer... i can tell you are good with Excel.

How do you get the dark lines?

Could not figure how you got the double in one space e.g time at top in cell and in at bottom in same cell

to fast for me!!!!!!!!!

You need to slow down and show what you are pressing please because what the hell is F6? When I click on that I get computer screen options! Was following along alright until that part then it all went out the window. Plus when I did the money part I followed the steps of selecting all column E and mine kept saying value ??

Too fast couldn’t catch up