I would like to say Thank You very much for demonstrating how to create this spreadsheet. Over the last few weeks, when time has allowed, i have created a similar sheet just for my own attendance throughout the year. Keeping an eye on how much Holiday i have used etc... I don't know where most of us would be without Videos created by your goodself & many others on TH-cam. Will have a look now at what other topics you have covered :-)
i have a question. lets say if we add an employee to the company during middle of the year. how do we add that employee to all the sheets? manually ? or is there a better way?
Highlight the cells, go to format cells (CTRL + 1) and then choose custom from the number tab. In "type" box enter d this will return 01/01/2024 as 1. Hope that helps :) Great video @NETVN82
I figured it out - for those other that wonder - - \( 1 \) hour is \( 0.125 \) of an 8-hour day. - \( 2 \) hours is \( 0.25 \) of an 8-hour day. - \( 3 \) hours is \( 0.375 \) of an 8-hour day. - \( 5 \) hours is \( 0.625 \) of an 8-hour day. - \( 6 \) hours is \( 0.75 \) of an 8-hour day. - \( 7 \) hours is \( 0.875 \) of an 8-hour day. Formula that worked better for the hours was this: (P - being personal time; Made the same for V being Vacation) This gave you 1 Day, 2 hrs., 4 hrs or 1/2 day., 6 hrs.) increments of 2 hrs. =SUMPRODUCT((A74:AE74="P")*1+(A74:AE74="P2")*0.25+(A74:AE74="P4")*0.5+(A74:AE74="P6")*0.75+(A74:AE74="PX")*1)
Hi Boss Can u pls make Video on how to prevent files retirement from Mobile after reset it to Factory default beleive or not I reset my Samsung Galaxy 4 to Factory Default by my friend shows me how to restore the previous files (Video , Doc , Images , chat history :) even with the factory default Thanks
Thank you for sharing a link to your spreadsheet! This is a lifesaver!!!
I would like to say Thank You very much for demonstrating how to create this spreadsheet. Over the last few weeks, when time has allowed, i have created a similar sheet just for my own attendance throughout the year. Keeping an eye on how much Holiday i have used etc... I don't know where most of us would be without Videos created by your goodself & many others on TH-cam. Will have a look now at what other topics you have covered :-)
Thank you! This was very helpful and I learned a lot!! Blessings and happy holidays
Great video... can you make a video on how to add reasons for leave?
Thanks a lot we’re really appreciate your efforts
So nice of you
i have a question. lets say if we add an employee to the company during middle of the year. how do we add that employee to all the sheets? manually ? or is there a better way?
Suggest any good open source Computer Repair service management softwares with advanced features
A làm thêm hướng dẫn setup SnipeIT đi anh ơi
Thank you. awesome video sir. Really helpful.
How did you make the date cell shows the day number instead of the whole date?
Highlight the cells, go to format cells (CTRL + 1) and then choose custom from the number tab. In "type" box enter d this will return 01/01/2024 as 1. Hope that helps :) Great video @NETVN82
Thank you heaps on this , you are amaxing
Hello, the link isn't working for me. Anyway you can link the file in this comment thread?
i have a question, how to calculate if the leave was only hours and minutes?
Thanks!!! That was a great help...
is this applicable for google sheet?
Thank you so much for this!
Very good thank you budd for sharing this :)
Question, what if the employee wanted to take off just an hour, or 2 hours, 3 hours.... or 5 or 6 or 7 hours? Is there a way to do that?
I figured it out - for those other that wonder -
- \( 1 \) hour is \( 0.125 \) of an 8-hour day.
- \( 2 \) hours is \( 0.25 \) of an 8-hour day.
- \( 3 \) hours is \( 0.375 \) of an 8-hour day.
- \( 5 \) hours is \( 0.625 \) of an 8-hour day.
- \( 6 \) hours is \( 0.75 \) of an 8-hour day.
- \( 7 \) hours is \( 0.875 \) of an 8-hour day.
Formula that worked better for the hours was this: (P - being personal time; Made the same for V being Vacation) This gave you 1 Day, 2 hrs., 4 hrs or 1/2 day., 6 hrs.) increments of 2 hrs.
=SUMPRODUCT((A74:AE74="P")*1+(A74:AE74="P2")*0.25+(A74:AE74="P4")*0.5+(A74:AE74="P6")*0.75+(A74:AE74="PX")*1)
The file can be edit
I want to track employees who are often taking leaves on Friday and Saturday. Can anyone help me out...
tìm hiểu và làm video về OSTicket đi admin
Do you have a link to the file?
Sample file bit.ly/3E2uATh
@@NETVN82 Thank you so much!! ☺🤝
What is the formula for the year sheet?
How you take date like 1,2,3 instead of 1-1-2024.because I used same formula but its showing like 1-1-2024
Format cell , then date , then choose which date formula you want
Add Tracking remaining PTO?
Hi Boss
Can u pls make Video on how to prevent files retirement from Mobile after reset it to Factory default
beleive or not I reset my Samsung Galaxy 4 to Factory Default by my friend shows me how to restore the previous files (Video , Doc , Images , chat history :) even with the factory default
Thanks
Thank you so much
Can someone please tell the formula used in the video
How to install prometheus with grafana pls you do best tutorials
Pls add video gentleman 🎉
Rumus uda sesuia diatas tapi kenapa gabisa ya tolong bantu jawab
Thanks!
Why is my year formula not working
I figured it out.
I can deal with the computerized narration. The music in the background was really distracting, though.
Thx
HOW TO ADD HOLIDAYS?
W0w❤❤❤❤❤❤