RU-vid tube pe aj tak ki best video hai bhai amazing esi tricks ksi or youtuber sa nhi mili ..........sometimes data enter sheet two mai kr rha hota hn but wo automatically sheet one mai chala jata hai kindly yeh samsaya solve krwa do
Superb yarr meri abhi job lagi 10000/- ke sallary pr mujhe excel pr work karna hota hai aapki itni sari trick aapne batayi kua baat hai guru chaa gaye... I love you yarr bahut hi acchi tarah se samjhaya
Hello There! i want one excel Formula > how to calculate OT1, OT2, Regular hour in excel. if hours fall between 00:00 to 05:00 it is OT2 , if hours fall between 05:00 to 8:30 it is OT1, if hours fall between 8:30 to 18:00 it is regular hour, if hours fall between18:00 to 21:00 it is OT1, if hours fall between 21:00 to 24:00 is OT2. For example if employee starts work at 02:00 and ends at 22:00 then total working hour will be 20:00, Regular Hour will be 09:30, OT1 will 06:30 , OT2 will be 04:00. (OT=OVERTIME)
Great video very helpful... But how can we remember so many shortcut keys you told in the ending..better we perform this manually than shortcut ...it will be better I think to do manually then shortcut keys like all border/autofit column etc
Aapne jo bhi btaya wo bht behtrin hai.. But 1 sikayat h... Plz show formulas on screen while applying.. So we can note it down... Mene video download kr lia.. Ab usko baar baar forward backward krke dekh ke sun ke likhna padd rha hai.. Which is irritating... Hope u understand my point... Like other youtubers
Hi . Nice video. But I have a question ❓ please. In the formula of pencil which was already discussed like pencil boxes or boxes . My question is how we can count the number of pencils in each box. (condition some box has less pencil compared to standard)