Monthly Attendance sheet for Limited Company employees Advance Formula
Вставка
- Опубліковано 5 вер 2024
- Attendance sheet has been made in this video and along with in time and out time, along with salary, automatic withdrawal has also been done.
Gate pass Entry Register Design for Limited Company • Gate pass Entry Regist...
Monthly production Report Limited company
• Monthly production Rep...
Traning Sheet Download:- drive.google.c...
Friends on this channel you are given absolutely original information about Microsoft Word Microsoft Excel Power Point Video Mixing Computer Hardware Laptop Hardware Online Information.
Friends, before uploading videos on this channel, it is kept in mind that this video should benefit you and you can learn a lot from one video.
Where does the friend go, no one has any work
My instagram Link : / ctechindia
My Instagram Personal Link : / chandan.ctech
Facebook Page Link: / ctechindia
My Other Hindi Channels:
Real Tutorial : ✅
/ @designapna
My Website: www.designapna...
#excel #Attendancesheet
वीडियो तो मैं अभिमन्यु भाई की भी देखता हूँ लेकिन तुम्हारा जो तरीका है न जूम करने का जो तुम्हारी वीडियो की क्लैरिटी है वो मुझे बहुत पसंद आती है
Salute you. From Pakistan for informative video
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
ismai overtime bhi add kijiye wo agar count karna hotoo kiyaa karna hogaa
thank you so much for providing this work sheet
kitni kaam ki video hai, Sir salute you
भाई मेरी टाइल्स कि दुकान है तो ईस पर भी वीडीओ बनाओ प्लीज
Great Sheet..Just one query how to Add Leave & Work from Home in forumula so that there in no error in total working time.
चन्दन भाई तुम तो छा गए गुरु मान गए
Video to achhi he but me puchhna chahungi ki jab apne 26 din ka pahle hi calculation kar diya he tab 1 se lekar 31 tak mtlb pure month ka in or out timr maintain krenge to fir kese sahi calculation aayega
Meri bi yhi problem h
Bro agar kisi employees ka night shift ha to kese calculate hoga. PM se AM nehi ho raha hai pls slove bro
Bna do sir ji PM To AM
Bhai purchase order keliye ek tutorial bna do 👍
sir ek problem hai aap ne ye wala formula nahi chal raha hai attendence sheet ke
=if((F3-E3)*24
भाई मेरी टाईल्स की दुकान है तो इस पर भी विडिओ बनाओ प्लीज
what if in time is 9:00 AM and out time is 1:00 AM? what formula will solve this? in your work sheet, in said situation, calculated hours are 0. Plz guide
Sir jiski night mai duty hoga pm to am time calculate kaise hoga. Yadi bich mai pm to am absent rahta hai to kaise higa
Is main (present, absent, week off, and publice holiday) kese count krenge
thank you so much its very signal progaram for all
Kya aap bata sakte h night shift me jate h .uska kaise nikale
assalamoalikum, everyone , mujy bohot afsoos hota hai, jb ek bohot kaam ki video ho, to na koi dekhta hai, aor na koi like karta hai, hum bohot jaahil qoum hai,
Hello sir.।
Sir monthly sheet me amount nahi nikal rahi. Formula bhi sahi lagaya h. Par (#value!) . Ye dikha raha h 😥😥
sir point of sale (pos) ka video banaye please
Thank you so much ❤❤
Thanking you sirji
Agar koi employee 10minute late aaya aur 30minute kam karna hai to kaisa hoga please
Guru ji Sunday Wale dono columns ko formatting se kaise highlight kren wo to bta dete yar
Sir agar in time out time or lunch time ho to kya formula hoga jaise mujhe thekedaaro ke bando ki attendance maintain karne ko bola hai jisme Kai baar wo dupehr se hi nhi ate
Bro ek video mere liya bana di
Daily ka attendance and daily advance ka
Roj ketana paisa lete hai please bro🙏🙏🙏🙏🙏
Sir mujhe apne in time mein ( 8am to 1:00pm ) or out time mein (2pm to 7pm ) rakhna hai
Ab iska formula kya hoga ??
Hi C TECH, I need your help on the same kind of work.
I need to highlight random but cinsecutive2 days week off for random 4 or 5 employee out of 20 every week. i have a ready sheet but i am unable to put in WeekOff in this way. can you really help?
time calculation ki video ka link nhi hai description me
Aoa sir you are writing round figure time if i have written as 9.25 pm then what we will be do it?please what you will be do it clear ?
Hello sir kya ap balance sheet ka upar koi video banate ho
Sir. Agr kisi ki absent ya Leave lgani ho wo kesy lga skty hn? Please answer me & is sheet me Duty time k ilawa jo over time lgaty hn usky charges alga hoty hn. Means duty time k hours 9 hn or over time k pesy 6 hours k hisab sy dety hn. Zra please isko details smjhaye ga
Uske liye alag sheet bana huaa hai , isme bhi ho sakta hai
sir night shift wala formula bta dijiye ki minus me kese kre
month change karna ho to poori sheet fir se maintain karni padegi
Excellent
nice video, thank you, how to set login logout button time want to save automatically without admin permission know one cont edit any formula are any suggestion?
Sir isme overtime bhi add karna tha
SUNDAY OVERTIME NOT SHOW IN THIS SHEET PLS HELP
Sunday time is not show this sheet
Kesy hn brother,,
Please ap hmen ye bta sakty hn k , jesy ap ne Attendance sheet bnai ek shet p,, to Kya is shet p Jo Total time or pay banti he, wo 2nd shet p Atto entri ho sakti he har employee k name k sath,,
Matlab k in or out time na ho, Baki same entire ho second shet p,,
Bhai jis din emp nhi aaya usko kese karnge or kisi labour ne rat ko 2 baje tak kaam kiya usko kese karnge
Thank you👍
Please PM to AM nhi ho pa raha hai set kese hoga ye formula bta dijiye bhai…
Ye ha pe Working time nikalneki 2 formula hai...but which formula is perfect. = if((end time- start time)*248,8,
Sir, shiftwis shift A 7am to 2pm
Shift B 2pm to 9pm
Formula kiya hoga pls share this
Agr over time bi nikalana ho isma or agr koi chutti pr h to kasa kra
Sir issue aa rha hai is mai ek. Kya ap resolve ker dain gy?
Bhai isme problem aa rahi 24 ghante ke Time ko Calculation nhi kar raha he
To do this, all merged cells need to be the same size sir ye kiya bata raha hai
isme kisika agar short time calculate karna ho to kese karenge
Agar 10 days continue working hote h uska formula
which version you are using of office..............?
training dete ho ap kya excel ki mujhe excel poora shikhna h please btaye
Agar sallary reports 25 worker ki sallary fill hoti or baki 15 nohi hoti to kese kore
Kia is sheet ko computer ma bana ke mobile use kar skta ha plez bata de our dosra bat he ki ap me jo ye sheet banya ya ham kisa download kar ke use karskti ha
Hello bro if duty time start 3pm how to put formula in this sheet
Agar koi absent ho jaye to usko kaise entry kare
bhai meri tiles ka shop hai. to is par bhi video banao plese
Ismein absent rahata hai To usko kaise kya Karen
Duty 8 hour ki ho or usna duty 24 ghanta ki ho to Kasa niklaa over time
Formula is not working is showing error
Sir Psphoto shop k video kab aayege ???
Formula are not working
Sir Please Ek video Blog Kesy Tyar Karty hai par bana deen please please sir please
Sir ye batao ki laptop main ms word kaise aur kis web site se download kare free main
Thank you so much
Thankyou so much I didn't.😎
sir hum kitne din me excel sikha jayenge
Sir es sheet me over time kaise nikalne???
Please make video pm to am
Sab ki problem galata hai
Sir ek page par print kaise hoga bta do
night shif worker ke liye formula help kariye sir
9:50 &10:20 ka karo
HALF DAY KAISSE CALCULATE HOGA ISME.
Mujhe count karna hai ki pure month me kitne din late aaya. Kaise count kare
pls formula bataye
Hi some errors showing
Bhai pinnacle ke vidio do na please
TOTAL WORKING DAY KE FARMULE ME PROVALM ARHI HAI
Intie and out time showings error
Cell column width badha lo,, ye property change kar lo,, sahi ho jayega
Khan h video in out ki alg se
सर आप एक साथ बहूत सारे स्कूल iD कार्ड कैसे बनाएं बताए
ye sheet mil nahi jayegi
Ecommerce work Krna portal pr kya hota h
Amazon flipcart, ye sab e-commerce me hi aate hai
Sir monthly sheet me amount nahi nikal rahi. Formula bhi sahi lagaya h. Par (#value!) . Ye dikha raha h 😥😥
Please provide the link of calculating time.
so sad
@@C-TECH please wo time count ka link dijiye.
Hi sir
Bhai minutes me calculation wrong aa raha hai
Farmula galat hai
Sir please provide formula
Bhai vidio mixing karna chahta hu
Nice but
One other thing need to be added in this sheet...
An employee came late n he didn't mention his time but he mention his out time how do u calculate his half day...
Time in : missing
Time out 06:00 pm
Time in : 08:00
Time out : missing
How to calculate half day
Mare pase to Shi to nhi chla
Har koi formula galat hai minute ka karo
A
=if code
Formula is rong
Wrong formula
सर आपका वाट्सएप नम्बर दीजिए
Apka number mil skta hai bro