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
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
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
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,,
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
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?
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
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,
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
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 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.
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
वीडियो तो मैं अभिमन्यु भाई की भी देखता हूँ लेकिन तुम्हारा जो तरीका है न जूम करने का जो तुम्हारी वीडियो की क्लैरिटी है वो मुझे बहुत पसंद आती है
kitni kaam ki video hai, Sir salute you
thank you so much for providing this work sheet
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
चन्दन भाई तुम तो छा गए गुरु मान गए
Great Sheet..Just one query how to Add Leave & Work from Home in forumula so that there in no error in total working time.
Bhai purchase order keliye ek tutorial bna do 👍
thank you so much its very signal progaram for all
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
ismai overtime bhi add kijiye wo agar count karna hotoo kiyaa karna hogaa
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 mujhe apne in time mein ( 8am to 1:00pm ) or out time mein (2pm to 7pm ) rakhna hai
Ab iska formula kya hoga ??
Thank you so much ❤❤
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.।
Sir monthly sheet me amount nahi nikal rahi. Formula bhi sahi lagaya h. Par (#value!) . Ye dikha raha 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
Thanking you sirji
Agar koi employee 10minute late aaya aur 30minute kam karna hai to kaisa hoga please
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
sir ek problem hai aap ne ye wala formula nahi chal raha hai attendence sheet ke
=if((F3-E3)*24
#VALUE! ah raha hai
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,,
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
Kya aap bata sakte h night shift me jate h .uska kaise nikale
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?
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
Is main (present, absent, week off, and publice holiday) kese count krenge
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,
SUNDAY OVERTIME NOT SHOW IN THIS SHEET PLS HELP
Sunday time is not show this sheet
sir point of sale (pos) ka video banaye please
Agr over time bi nikalana ho isma or agr koi chutti pr h to kasa kra
Excellent
training dete ho ap kya excel ki mujhe excel poora shikhna h please btaye
time calculation ki video ka link nhi hai description me
Hello sir kya ap balance sheet ka upar koi video banate ho
sir night shift wala formula bta dijiye ki minus me kese kre
Please PM to AM nhi ho pa raha hai set kese hoga ye formula bta dijiye bhai…
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
Thank you👍
Sir isme overtime bhi add karna tha
Sir Psphoto shop k video kab aayege ???
Sir issue aa rha hai is mai ek. Kya ap resolve ker dain gy?
Guru ji Sunday Wale dono columns ko formatting se kaise highlight kren wo to bta dete yar
Sir, shiftwis shift A 7am to 2pm
Shift B 2pm to 9pm
Formula kiya hoga pls share this
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 so much
Agar sallary reports 25 worker ki sallary fill hoti or baki 15 nohi hoti to kese kore
Agar 10 days continue working hote h uska formula
which version you are using of office..............?
Hello bro if duty time start 3pm how to put formula in this sheet
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?
isme kisika agar short time calculate karna ho to kese karenge
To do this, all merged cells need to be the same size sir ye kiya bata raha hai
Thankyou so much I didn't.😎
sir hum kitne din me excel sikha jayenge
Bro ek video mere liya bana di
Daily ka attendance and daily advance ka
Roj ketana paisa lete hai please bro🙏🙏🙏🙏🙏
Duty 8 hour ki ho or usna duty 24 ghanta ki ho to Kasa niklaa over time
Ye ha pe Working time nikalneki 2 formula hai...but which formula is perfect. = if((end time- start time)*248,8,
Bhai isme problem aa rahi 24 ghante ke Time ko Calculation nhi kar raha he
Formula is not working is showing error
bhai meri tiles ka shop hai. to is par bhi video banao plese
Agar koi absent ho jaye to usko kaise entry kare
Sir ye batao ki laptop main ms word kaise aur kis web site se download kare free main
Sir es sheet me over time kaise nikalne???
Mujhe count karna hai ki pure month me kitne din late aaya. Kaise count kare
pls formula bataye
Sir Please Ek video Blog Kesy Tyar Karty hai par bana deen please please sir please
Formula are not working
Ismein absent rahata hai To usko kaise kya Karen
Please make video pm to am
Sir ek page par print kaise hoga bta do
Bhai pinnacle ke vidio do na please
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.
night shif worker ke liye formula help kariye sir
Sab ki problem galata hai
सर आप एक साथ बहूत सारे स्कूल iD कार्ड कैसे बनाएं बताए
Hi sir
TOTAL WORKING DAY KE FARMULE ME PROVALM ARHI HAI
9:50 &10:20 ka karo
Hi some errors showing
ye sheet mil nahi jayegi
Intie and out time showings error
Cell column width badha lo,, ye property change kar lo,, sahi ho jayega
Farmula galat hai
Bhai minutes me calculation wrong aa raha hai
Bhai vidio mixing karna chahta hu
Har koi formula galat hai minute ka karo
Khan h video in out ki alg se
Mare pase to Shi to nhi chla
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
A
Nice but
Formula is rong
Wrong formula
=if code
Sir please provide formula
सर आपका वाट्सएप नम्बर दीजिए
Apka number mil skta hai bro
सर आपका वाट्सएप नम्बर दीजिए