There is a problem, if you can help me, when we change the month, the old data remains. How can I make the data (P, A etc.) adapt to the selected month?
@lasthope3656
7 ай бұрын
Hallo sir I asked attendance sheet automatically updated through bio matric data
@Office-Monk
7 ай бұрын
You will have to mail me the format which gets downloaded from Biometrics. Based on that I can create a format. So that you will have to copy paste the Biometrics data in Excel format and all the components will be calculated
@fact_bd87
3 ай бұрын
Hi, How to count everyday present , absent etc separately. TIA for help.
@Office-Monk
3 ай бұрын
You can use COUNTIF
@Moorthi-
7 ай бұрын
In Excel, if we move one heading below one heading in ABC row, the size of two headings changes. If you move the ABC row, the size of the heading at the top should remain the same. The heading below should be resized and changed. Tell me how to do this.
@Office-Monk
7 ай бұрын
Your qs is not clear to me. Plz provide me all the details
@sanjayshrestha3013
7 ай бұрын
Based on this attendance data upload a new video in which we can caculate weekly working hrs, weekly negative and excess hrs,
@Office-Monk
6 ай бұрын
Sure. I will try to create one. Thank you for you comment 😊😊😊
@myldot2586
5 ай бұрын
i've create the sheet completely. However, when i choose February, the column data for date 30,31 from January still appear. Please advise what should do ?
@Office-Monk
5 ай бұрын
Please send me the formula of 2nd date
@harisp338
7 ай бұрын
Hi , Vijay How to calculate difference value between two no#, like there are only positive value and negative values. Ex: 5300-5200=100 ,which is 100 deficit 5200-5300 =-100, which is 100 surplus, can you please help out ..any formula for large data ..
@Office-Monk
6 ай бұрын
Hi Harish, I haven't got your point. Can you please mail me the example file.
@lasthope3656
7 ай бұрын
And chenge month vanish all details last month data
@KainatFatima-mi2kw
3 ай бұрын
How can i merge 12 months attendance in 1 sheet..
@Office-Monk
3 ай бұрын
Please watch my latest video of Attendance Sheet. I have managed all the months in a single sheet
@andreamaebutalid4647
5 ай бұрын
The date 30 and 31 when I select something it won't be counted
@Office-Monk
5 ай бұрын
Haven't got your point Sir. Can you please elaborate
@andreamaebutalid4647
5 ай бұрын
@@Office-Monk when I select CL or P or A on date 30 and 31 of the month it won't be counted in the P or A cell no 1 will be display
@Office-Monk
5 ай бұрын
Some on edited the formulas on line. I changed it back. Now you can check it. Now It's picking up all the things properly
@andreamaebutalid4647
5 ай бұрын
@@Office-Monk It's still the same sir. Date 30 and 31 if I select Present it won't add 1 in Present Row
@Office-Monk
5 ай бұрын
Mail me the file please. vijaymuukh@gmail.com
@Bob-bh9kh
4 ай бұрын
There is a problem, if you can help me, when we change the month, the old data remains. How can I make the data (P, A etc.) adapt to the selected month?
@Office-Monk
4 ай бұрын
Hi Bob, this sheet is just for 1 month. For 12 months, you will have to create 12 sheets. Just by changing the month from the dropdown, data is not going to change or erased
@anandakumar8013
2 ай бұрын
Hai sir Please display large size when you are creating formulas
Пікірлер: 27