Hi brother- I tried do the same things but once I click on admin then on other sheet date is coming in time format. Can you explain why after changing date format again showing time format in the date column.
Dear i saw ur videosss v nice Please ek video aur bnayein. Pvt schools hetu, biometric attendance ki app excel se kaise bnayein jis se staff biometric fingerprint ka use kr k excel me convert ho jaye
Really!? you don't know what biometric system is 👎 . Please do not loose your credibility by using false captions and clickbait thumbnails. I have learned a lot of things from your videos, please do not lose your credibility for views and likes.
Hi, I need to take report of employee who loged in between 8.00 am to 8.10 am. Can you let me know the formula for the same... Also some employees have not punched the biometric in morning so I need you avoid that and count .. please help me on this.
Is formula me 2nd if ka kia kam (If(B2"",B2,Now()))? Jis cell pr ap formula laga rhe hn usse cell ki condition lg hi ni sakhti shyd. Confusion create ho rhi hy dear. Without 2nd if k kam perfect hota hy "=if(A2"","",Now())".
Sun 01 may-24 Mon 02 may -24 Tue 03 may - 24 Wed 04 may - 24 Thu 05 may - 24 Fri 06 may -24 Sat 07 may -24 Sun 08 may-24. SAME TYPEING One month tricks available sir Tell me please help me 🙏🙏
Pehle ap 1st cell pe date likhe 01-05-2024 phir enter kr k save kr len date . Phir ussi cell k format cells me jaen (cell select kr k Ctrl+! Ya Ctrl+1 press krn) customer me ja kr wahan likhen ye "DDD DD MMM-YYYY" phir okay kr len . Ap dekhenge cell ki value aesi ho chuki hogi "WED 01 MAY-2024" . ab ya is cell ko drag down kr len, ya to neche wale cell me formula likhen 1st cell + 1. Or us formula ko drag down kr len . Ab ap jb b 1st cell ki date change krnge niche sb jaga date change hogi ap k format k hisab se .
It's really, xl adda... excellent 👍
thank you so much mera masla hal kr dia
I require like this format, but each person time sheet make separate on their name and aggregate on the end of each month.
Awesome useful sheet, how to sort Monday to Sunday number of people working in single day present or absent
Assalamualikum..
How to analize biomatric attendance
Super bhai
Assalamoalaykum Awesome JazakAllah MashaAllah greatest very useful sheet JazakAllah Aameen
Hi brother- I tried do the same things but once I click on admin then on other sheet date is coming in time format. Can you explain why after changing date format again showing time format in the date column.
Dear i saw ur videosss v nice
Please ek video aur bnayein. Pvt schools hetu, biometric attendance ki app excel se kaise bnayein jis se staff biometric fingerprint ka use kr k excel me convert ho jaye
Nhi bnayenge jo asal cheez he nhi btayenge
Thank you sir 🙏🙏🙏🙏
Where is thumb impression authentication?
Really!? you don't know what biometric system is 👎 . Please do not loose your credibility by using false captions and clickbait thumbnails. I have learned a lot of things from your videos, please do not lose your credibility for views and likes.
Hume staff ka duty roster banana hai pr har staff ka week off alag alag din
Hi,
I need to take report of employee who loged in between 8.00 am to 8.10 am. Can you let me know the formula for the same...
Also some employees have not punched the biometric in morning so I need you avoid that and count .. please help me on this.
I will upload this topic soon
How can we will import data of POS machine to Excel sheet
Mantra device sai attendance kaise bhare
Salam
Sir mera question y hi
Mujy insert row nhee krna.
To kia krain.
Down table main Q nhee jaiga
Please please
Reply
out time kassy excel mai set karty hai
Sheet me staff ka present ke din week off bataye
Ismai in out total hours sb mention hona chye
Sir
Your formula of =if isn't working
Cell blank hi rhta h name likhny sy b
No biometric
Is formula me 2nd if ka kia kam (If(B2"",B2,Now()))? Jis cell pr ap formula laga rhe hn usse cell ki condition lg hi ni sakhti shyd. Confusion create ho rhi hy dear.
Without 2nd if k kam perfect hota hy "=if(A2"","",Now())".
Sun 01 may-24
Mon 02 may -24
Tue 03 may - 24
Wed 04 may - 24
Thu 05 may - 24
Fri 06 may -24
Sat 07 may -24
Sun 08 may-24. SAME TYPEING
One month tricks available sir
Tell me please help me 🙏🙏
Please help me 🙏
Pehle ap 1st cell pe date likhe 01-05-2024 phir enter kr k save kr len date . Phir ussi cell k format cells me jaen (cell select kr k Ctrl+! Ya Ctrl+1 press krn) customer me ja kr wahan likhen ye "DDD DD MMM-YYYY" phir okay kr len . Ap dekhenge cell ki value aesi ho chuki hogi "WED 01 MAY-2024" . ab ya is cell ko drag down kr len, ya to neche wale cell me formula likhen 1st cell + 1. Or us formula ko drag down kr len . Ab ap jb b 1st cell ki date change krnge niche sb jaga date change hogi ap k format k hisab se .
@@krishnathetchina8071 is it solve?
Where is the biometric?
Plz sir we want to benefit from you talk in English sir 😭or we want subtitles
Sir sorry this not bayometrick sheet
ENGLISH!!!!!!