Monthly Attendance sheet for Limited Company employees Advance Formula

[@nikhilkapoor82]

वीडियो तो मैं अभिमन्यु भाई की भी देखता हूँ लेकिन तुम्हारा जो तरीका है न जूम करने का जो तुम्हारी वीडियो की क्लैरिटी है वो मुझे बहुत पसंद आती है

[@shafaatkhan7737]

kitni kaam ki video hai, Sir salute you

[@sanketv1]

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

[@nashitraza4817]

Salute you. From Pakistan for informative video

[@shoponmia]

thank you so much for providing this work sheet

[@nikhilkapoor82]

चन्दन भाई तुम तो छा गए गुरु मान गए

[@GurpreetSingh-mn5fx]

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

[@jhasaurav786]

Great Sheet..Just one query how to Add Leave & Work from Home in forumula so that there in no error in total working time.

[@skinfo9138]

ismai overtime bhi add kijiye wo agar count karna hotoo kiyaa karna hogaa

[@amratjoshi2551]

भाई मेरी टाइल्स कि दुकान है तो ईस पर भी वीडीओ बनाओ प्लीज

[@kskinglysolutions1301]

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

[@anikettiwari9744]

Bhai purchase order keliye ek tutorial bna do 👍

[@abherambhaijoshi9759]

भाई मेरी टाईल्स की दुकान है तो इस पर भी विडिओ बनाओ प्लीज

[@rajeshsinghjadham9899]

Thanking you sirji Agar koi employee 10minute late aaya aur 30minute kam karna hai to kaisa hoga please

[@shafaatkhan7737]

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,

[@murtazaqureshi2876]

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,,

[@DharmendraKumar-ei1kv]

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

[@Simrandeep-uq4fy]

Sir mujhe apne in time mein ( 8am to 1:00pm ) or out time mein (2pm to 7pm ) rakhna hai Ab iska formula kya hoga ??

[@computermcqclass4493]

Bro agar kisi employees ka night shift ha to kese calculate hoga. PM se AM nehi ho raha hai pls slove bro

[@kasimraza9536]

Bna do sir ji PM To AM

[@MuhammadRizwan-hz7cp]

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

[@C-TECH]

Uske liye alag sheet bana huaa hai , isme bhi ho sakta hai

[@samie-vq5et]

Hello sir.। Sir monthly sheet me amount nahi nikal rahi. Formula bhi sahi lagaya h. Par (#value!) . Ye dikha raha h 😥😥

[@simakumari-kj1fu]

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

[@radhasingh8109]

Meri bi yhi problem h

[@anilkumar-gk5zk]

Kya aap bata sakte h night shift me jate h .uska kaise nikale

[@akhtarayub4669]

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 ?

[@vinlio7131]

training dete ho ap kya excel ki mujhe excel poora shikhna h please btaye

[@amjadali8408]

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

[@balliyadav4922]

sir ek problem hai aap ne ye wala formula nahi chal raha hai attendence sheet ke =if((F3-E3)*24

[@dilhaikimantanehi3367]

#VALUE! ah raha hai

[@kuldeeptyagi9802]

Agr over time bi nikalana ho isma or agr koi chutti pr h to kasa kra

[@abdulbashiramarkhil5582]

thank you so much its very signal progaram for all

[@aadilshaikh8376]

Sir Psphoto shop k video kab aayege ???

[@natiksaifi]

time calculation ki video ka link nhi hai description me

[@mayas5452]

Sir isme overtime bhi add karna tha

[@kasimraza9536]

Please PM to AM nhi ho pa raha hai set kese hoga ye formula bta dijiye bhai…

[@nashitraza4817]

Sir issue aa rha hai is mai ek. Kya ap resolve ker dain gy?

[@shahadathossain839]

Hello sir kya ap balance sheet ka upar koi video banate ho

[@abhinavraj7456]

sir point of sale (pos) ka video banaye please

[@shakirpathan05]

SUNDAY OVERTIME NOT SHOW IN THIS SHEET PLS HELP

[@anjusingh-hf3mr]

Sunday time is not show this sheet

[@vinlio7131]

sir night shift wala formula bta dijiye ki minus me kese kre

[@PraveenSuthar-o7u]

Bhai jis din emp nhi aaya usko kese karnge or kisi labour ne rat ko 2 baje tak kaam kiya usko kese karnge

[@abhi.nikgaming]

Is main (present, absent, week off, and publice holiday) kese count krenge

[@rajatyagi6790]

Guru ji Sunday Wale dono columns ko formatting se kaise highlight kren wo to bta dete yar

[@ankitlimba738]

Sir, shiftwis shift A 7am to 2pm Shift B 2pm to 9pm Formula kiya hoga pls share this

[@ShyamSundar98213]

Bro ek video mere liya bana di Daily ka attendance and daily advance ka Roj ketana paisa lete hai please bro🙏🙏🙏🙏🙏

[@vasavapiyushbhai9405]

Agar sallary reports 25 worker ki sallary fill hoti or baki 15 nohi hoti to kese kore

[@ArvindKumar-wz5qz]

sir hum kitne din me excel sikha jayenge

[@VinayYadav-xf7vg]

isme kisika agar short time calculate karna ho to kese karenge

[@BHARDWAJ_ROHIT]

Agar 10 days continue working hote h uska formula

[@shanuorsiddharthmusicoffic8404]

Sir ye batao ki laptop main ms word kaise aur kis web site se download kare free main

[@kumarsharmaajit4811]

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?

[@abherambhaijoshi]

bhai meri tiles ka shop hai. to is par bhi video banao plese

[@saylanimasshyderabad4293]

which version you are using of office..............?

[@fithitssongs33]

Thank you so much ❤❤

[@kuldeeptyagi9802]

Duty 8 hour ki ho or usna duty 24 ghanta ki ho to Kasa niklaa over time

[@bhandibalu6857]

Hello bro if duty time start 3pm how to put formula in this sheet

[@luckyrana.093]

Bhai isme problem aa rahi 24 ghante ke Time ko Calculation nhi kar raha he

[@sabiralichaudhary9241]

To do this, all merged cells need to be the same size sir ye kiya bata raha hai

[@exloretheknowledge0108]

Sir es sheet me over time kaise nikalne???

[@redbudes]

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?

[@chouhaanchouhaan5967]

Sir Please Ek video Blog Kesy Tyar Karty hai par bana deen please please sir please

[@ibrahimcomputerart7301]

Excellent

[@kanhaiyagupta670]

Mujhe count karna hai ki pure month me kitne din late aaya. Kaise count kare

[@kanhaiyagupta670]

pls formula bataye

[@babu__malindar5911]

Agar koi absent ho jaye to usko kaise entry kare

[@fihaalam2455]

Ye ha pe Working time nikalneki 2 formula hai...but which formula is perfect. = if((end time- start time)*248,8,

[@babu__malindar5911]

Ismein absent rahata hai To usko kaise kya Karen

[@shruthigowda2892]

Formula is not working is showing error

[@deepakbhagat5376]

Sir ek page par print kaise hoga bta do

[@rupalilokhande8504]

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.

[@C-TECH]

so sad

[@rupalilokhande8504]

@@C-TECH please wo time count ka link dijiye.

[@niteshmaurya9275]

Thankyou so much I didn't.😎

[@truthlover6511]

Thank you👍

[@mahendrapawar8009]

Bhai pinnacle ke vidio do na please

[@mayurpitroda]

night shif worker ke liye formula help kariye sir

[@PoojaKumari-vm6be]

Ecommerce work Krna portal pr kya hota h

[@C-TECH]

Amazon flipcart, ye sab e-commerce me hi aate hai

[@devvratbaghel3414]

सर आप एक साथ बहूत सारे स्कूल iD कार्ड कैसे बनाएं बताए

[@SushilKumar-od7sv]

TOTAL WORKING DAY KE FARMULE ME PROVALM ARHI HAI

[@MalkitSingh-gb5ep]

Please make video pm to am

[@mahendrapawar8009]

Bhai vidio mixing karna chahta hu

[@zainmushu5586]

Formula are not working

[@krishnaprajapati5411]

ye sheet mil nahi jayegi

[@rudrarana783]

Khan h video in out ki alg se

[@romaconvertor1090]

Bhai minutes me calculation wrong aa raha hai

[@yogeshsali688]

Hi sir

[@adiladil2261]

9:50 &10:20 ka karo

[@svinterior6827]

Hi some errors showing

[@kulwindersingh5021]

Mare pase to Shi to nhi chla

[@svinterior6827]

Intie and out time showings error

[@C-TECH]

Cell column width badha lo,, ye property change kar lo,, sahi ho jayega

[@adiladil2261]

Sab ki problem galata hai

[@bhanwarlalprajapat287]

Nice but

[@anilkumar-gk5zk]

Sir please provide formula

[@adiladil2261]

Har koi formula galat hai minute ka karo

[@AmandeepKaur-yo8eq]

Farmula galat hai

[@ajaztaj]

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

[@kulwindersingh5021]

Formula is rong

[@ChhotuKumar-ce3wf]

A

[@sangyaamalhotra6512]

Wrong formula

[@svinterior6827]

=if code

[@devvratbaghel3414]

सर आपका वाट्सएप नम्बर दीजिए

[@mrarslove4541]

Apka number mil skta hai bro

[@Armankhan-be9zk]

Thank you so much

[@devvratbaghel3414]

सर आपका वाट्सएप नम्बर दीजिए