Monthly Attendance sheet for Limited Company employees Advance Formula

Подписаться 634 тыс.

Просмотров 225 тыс.

50% 1

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

Опубликовано:

16 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 112

@nikhilkapoor82 4 года назад

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

@nashitraza4817 5 месяцев назад

Salute you. From Pakistan for informative video

@shoponmia 2 года назад

thank you so much for providing this work sheet

@shafaatkhan7737 8 месяцев назад

kitni kaam ki video hai, Sir salute you

@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.

@amratjoshi2551 4 года назад

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

@skinfo9138 11 месяцев назад

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

@nikhilkapoor82 4 года назад

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

@sanketv1 25 дней назад

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

@abherambhaijoshi9759 4 года назад

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

@anikettiwari9744 2 года назад

Bhai purchase order keliye ek tutorial bna do 👍

@abdulbashiramarkhil5582 4 года назад

thank you so much its very signal progaram for all

@computermcqclass4493 4 года назад

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

@kasimraza9536 2 года назад

Bna do sir ji PM To AM

@balliyadav4922 3 года назад

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

@shafaatkhan7737 8 месяцев назад

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,

@fithitssongs33 5 месяцев назад

Thank you so much ❤❤

@abhinavraj7456 4 года назад

sir point of sale (pos) ka video banaye please

@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

@kskinglysolutions1301 2 месяца назад

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

@abhi.nikgaming 4 месяца назад

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

@rajeshsinghjadham9899 2 года назад

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

@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

@anilkumar-gk5zk 2 года назад

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

@rajatyagi6790 8 месяцев назад

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

@ShyamSundar98213 6 месяцев назад

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

@shahadathossain839 4 года назад

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

@samie-vq5et 3 года назад

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

@ibrahimcomputerart7301 3 года назад

Excellent

@fihaalam2455 3 года назад

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

@GurpreetSingh-mn5fx 4 месяца назад

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

@akhtarayub4669 7 месяцев назад

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 ?

@redbudes 3 года назад

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?

@truthlover6511 2 года назад

Thank you👍

@vinlio7131 Год назад

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

@natiksaifi 4 года назад

time calculation ki video ka link nhi hai description me

@Armankhan-be9zk 2 года назад

Thank you so much

@kumarsharmaajit4811 2 года назад

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?

@Simrandeep-uq4fy 5 месяцев назад

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

@ankitlimba738 Год назад

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

@kasimraza9536 2 года назад

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

@saurabhchauhan890 2 года назад

month change karna ho to poori sheet fir se maintain karni padegi

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

@PraveenSuthar-o7u 10 месяцев назад

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

@kuldeeptyagi9802 9 месяцев назад

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

@abherambhaijoshi 3 года назад

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

@niteshmaurya9275 4 года назад

Thankyou so much I didn't.😎

@chouhaanchouhaan5967 3 года назад

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

@mayas5452 4 месяца назад

Sir isme overtime bhi add karna tha

@MuhammadRizwan-hz7cp 3 года назад

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 3 года назад

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

@vasavapiyushbhai9405 2 года назад

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

@sabiralichaudhary9241 Год назад

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

@BHARDWAJ_ROHIT Год назад

Agar 10 days continue working hote h uska formula

@VinayYadav-xf7vg Год назад

isme kisika agar short time calculate karna ho to kese karenge

@luckyrana.093 Год назад

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

@vinlio7131 2 года назад

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

@MalkitSingh-gb5ep 3 года назад

Please make video pm to am

@nashitraza4817 5 месяцев назад

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

@bhandibalu6857 Год назад

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

@amjadali8408 4 года назад

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

@shakirpathan05 6 месяцев назад

SUNDAY OVERTIME NOT SHOW IN THIS SHEET PLS HELP

@anjusingh-hf3mr 4 месяца назад

Sunday time is not show this sheet

@shanuorsiddharthmusicoffic8404 4 года назад

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

@kuldeeptyagi9802 9 месяцев назад

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

@babu__malindar5911 10 месяцев назад

Agar koi absent ho jaye to usko kaise entry kare

@saylanimasshyderabad4293 3 года назад

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

@aadilshaikh8376 4 года назад

Sir Psphoto shop k video kab aayege ???

@mayurpitroda 2 года назад

night shif worker ke liye formula help kariye sir

@babu__malindar5911 10 месяцев назад

Ismein absent rahata hai To usko kaise kya Karen

@shruthigowda2892 2 года назад

Formula is not working is showing error

@deepakbhagat5376 2 года назад

Sir ek page par print kaise hoga bta do

@ArvindKumar-wz5qz 3 года назад

sir hum kitne din me excel sikha jayenge

@mahendrapawar8009 4 года назад

Bhai pinnacle ke vidio do na please

@devvratbaghel3414 4 года назад

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

@yogeshsali688 2 года назад

Hi sir

@zainmushu5586 9 месяцев назад

Formula are not working

@SushilKumar-od7sv 2 года назад

TOTAL WORKING DAY KE FARMULE ME PROVALM ARHI HAI

@rudrarana783 2 года назад

Khan h video in out ki alg se

@exloretheknowledge0108 2 года назад

Sir es sheet me over time kaise nikalne???

@saurabhchauhan890 2 года назад

HALF DAY KAISSE CALCULATE HOGA ISME.

@adiladil2261 Год назад

Sab ki problem galata hai

@bhanwarlalprajapat287 3 года назад

Nice but

@adiladil2261 Год назад

9:50 &10:20 ka karo

@kanhaiyagupta670 3 года назад

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

@kanhaiyagupta670 3 года назад

pls formula bataye

@svinterior6827 4 года назад

Hi some errors showing

@anilkumar-gk5zk 2 года назад

Sir please provide formula

@romaconvertor1090 2 года назад

Bhai minutes me calculation wrong aa raha hai

@rupalilokhande8504 3 года назад

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 3 года назад

so sad

@rupalilokhande8504 3 года назад

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

@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

@mahendrapawar8009 4 года назад

Bhai vidio mixing karna chahta hu