๐๐ฆ๐ฉ๐ฅ๐จ๐ฒ๐๐ ๐๐๐๐ ๐๐๐๐๐๐๐ ๐ข๐ง ๐๐จ๐จ๐ ๐ฅ๐ ๐๐ก๐๐๐ญ๐ฌ ๐๐๐๐ / ๐๐ญ๐ญ๐๐ง๐๐๐ง๐๐ ๐๐ก๐๐๐ญ ๐ฐ๐ข๐ญ๐ก ๐๐ก๐๐๐ค ๐ข๐ง ๐๐ง๐ ๐๐ก๐๐๐ค ๐จ๐ฎ๐ญ ๐๐ข๐ฆ๐
HTML-ะบะพะด
- ะะฟัะฑะปะธะบะพะฒะฐะฝะพ: 8 ัะฝะฒ 2025
This is one of the perfect video i have been searched for. Very useful, doing great, Thank you!
Thank you so much for the appreciation. It really means a lot. Stay connected for such interesting formats and videos
my company works in 3 shifts(US, AUS, UK) and when an employee starts his/her shift , entry is made using ctrl+; & ctrl+shift+; , and similar thing is done when he/she takes break (2 times 30minutes in one day/shift) & also when completing day(8 hours). so doing 7:30 work in a continuous will make one day. (here us(night) shift person logs in @ 8 pm on a day and leaves @4 am next day. Anything above 7:30 is counted as Overtime and added in salary at overtime rate which is specified. Can you please make video showing how to make such dashbaord or calculation sheet.PLEASE PLEASE
I will try to come up with such format soon
What if the employees have different week off, what will be the formula?
You will get Video on this topic on my channel. Please check once
Very very nice and helpful for me thanks
Thank you so much ๐. Please stay connected for such interesting topics and formats
Hi I need access to the sheet please share the same.
Shared the file link on mail. Thank you
Hi i just finished making this Sheet following your steps. Everything is great except one thing that i noticed. In the formula of Overtime Hours We subtract working hours with ideal working hours. However when we copy and paste the formula for the next date since we did not press F4 for ideal working hours it picks up a different cell which gives us wrong calculation of Overtime Hours.
Ideal Working Hours: G6
Time in is in - H6
Time out is in - I6
Formula for Total Working Hours: =IF(I6="","0",IF(I6>H6,I6-H6,1+I6-$H$6)*24)
Formula for Total Working Hours: =IF(J6="0","0",(J6-$G6))
These are the Cell reference numbers and the formulas. I will cross check in case I missed something. Thanks Akash
Thank you for updating the sheet.
@@akashchhabra555 Most welcome ๐๐๐
Why am I getting an error with the formula =SUBTOTAL(3,$B$5,B5)? I expect the result to be 0, but when I add an Employee ID, the number changes to 2." it should be 1.
Instead of 3, try 9
how to mark present, absent, half day
If Time in and Time out will be marked, it's Present. If not marked, it's absent. If time in and time out is marked for 4 - 5 hours, it's half day. Seems you didn't understand the format. In case you want to mark P, A, HD, better follow Attendance Sheet, instead of Time Tracker
Can we make this sheet in excel??
On my Channel, you will get this Format in Excel
How to know total present day ?
In case you want to know total Present days, insert 1 column in each day and put the function of IF. When you will put entry time, it will show P in next cell. Now in the end insert 1 more column and in to use the function of Countif
Hi I have paid to be a member, how do i download this sheet now?
Hi Ashutosh,
Please drop me a mail on vijaymuukh@gmail.com
Could you respond?
How to respond now ? I already dropped a comment 35 minutes back and asked you to drop me a mail
Haven't got any mail from your side
Thank you this is very helpful, i am your new subscriber now
Thank you so much for loving the video and getting connected with the Channel ๐ Noted your points on the format of Anuual Project Tracker
@@Office-Monk Thank you sir โบ๐
@@Office-Monk Btw, i tried to put a keyword SL (sick leave) on some dates, and the formula's got error prompt , how to fix it sir?
vijaymuukh@gmail.com
Please share the format, I will check the issue
I have a google sheets, but Nepali date please.
You will have to select your own language in in Google Sheets