Calculate Time Difference in Excel - Malayalam Tutorial

  Рет қаралды 35,155

XL n CAD Malayalam

XL n CAD Malayalam

Күн бұрын

Пікірлер: 68
@jowhersadiq
@jowhersadiq 3 жыл бұрын
Super avatharanam anu.. very very clear talk and explanation
@goodheart9209
@goodheart9209 3 жыл бұрын
നല്ല അവതരണം എന്നിട്ടു Subscribers കുറവ്, വിഷമിക്കേണ്ട മുന്നോട്ട് പോവുക...
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
😀🙏
@sudheer8126
@sudheer8126 2 жыл бұрын
You should have given an explanation for "+1" in the formula.
@majojosek
@majojosek 3 жыл бұрын
Very informative
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Glad you think so!
@abbukad5947
@abbukad5947 2 жыл бұрын
This very helpful... thank you... How to cut salary for late coming Pls put a vedio
@apmriyas
@apmriyas 3 жыл бұрын
Sir, do u have tutorials about the data creation of purchases and shipment details? Such as order references and its status ( approved/cancelled/ shipped.. Etc) and shipment details such as shipping value, volume, container datas.. Etc...?? I have the excel datas in ordinary way which has more than 1000 orders references in each sheets.. It was difficult to manage it, but I need to learn in professional way😊😊😊... Thank you
@jishlike1288
@jishlike1288 3 жыл бұрын
Hi sir, ഷോപ്പിലെ ഡേ purchase, sale monthly profit and loss എക്സിലിൽ ചെയ്യുന്ന വീഡിയോ ചെയ്യാമോ?
@najeelas66
@najeelas66 2 жыл бұрын
Thank u sir ... Very easy steps 😜 thanks .... 🌹
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
My pleasure :)
@georgemichael845
@georgemichael845 3 жыл бұрын
Good and informative. Can u pls show how to add buttons in this excel which can display current time in a cell ?.
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
To know how to add buttons and controls into worksheets and assign actions those objects, check my videos on programming in Excel. For inserting Time stamps, you can use the following shortcuts Current Date : Ctrl + ; Current Date and Current Time : Ctrl + Shift + :
@georgemichael845
@georgemichael845 3 жыл бұрын
@@XLnCADMalayalam Thank u. Print preview as well ?.
@georgemichael845
@georgemichael845 3 жыл бұрын
@@XLnCADMalayalam Thanks. നോക്കിയിട്ടു video Link കാനുന്നില്ല link തരാമോ ?.
@jijeeshpadmanabhan350
@jijeeshpadmanabhan350 3 жыл бұрын
Very informative. Thank you sir
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
You are welcome
@kannan4545
@kannan4545 3 жыл бұрын
Hi sir LIFO, FIFO STOCK VALUATION ചെയ്യാമോ plz
@sunilkumar-ph2mz
@sunilkumar-ph2mz 2 жыл бұрын
Could you please create a formula for normal OT public holiday OT in a sheet
@eldhomv4751
@eldhomv4751 3 жыл бұрын
Excellent and very informative sessions 👍can pls do a video about printing excel dashboard with image background Thank you
@mask_alwalker
@mask_alwalker 3 жыл бұрын
Sir excel page number footer l like page 1, page2, page3 kanikkan patto print edukkumbol oru quotationil 4 pages break cheythittundenkil . page settup header and footeril enganeyan athinte settings .
@sunuvinu007
@sunuvinu007 3 жыл бұрын
Awasome.. 🙏👌👌 thanks sir😍
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Most welcome 😊
@deekshitha6931
@deekshitha6931 2 жыл бұрын
Postal RD Agentinte software exelil create cheyyunna reethi paranju tharumo
@thetru4659
@thetru4659 3 жыл бұрын
ഫോർമാറ്റുകൾ zoom ചെയ്ത് കാണിച്ചാൽ നന്നായിരിക്കും
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Sure
@oommenrinosh
@oommenrinosh 2 жыл бұрын
Hi! I would like to reduce break time from this total hrs worked, so what changes I have to do? Thank you
@mohammednanath8853
@mohammednanath8853 3 жыл бұрын
Please explain the logic of adding +1 in the formula
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
For better understanding, you can read the formula other way around. 1 - Start Time + End Time. By subtracting Start Time from 1, you will get the amount of time in the first day and that value is added to the amount of time in the second day , which is same as the End Time.
@mohammednanath8853
@mohammednanath8853 3 жыл бұрын
@@XLnCADMalayalam thanks for the explanation
@fun6842
@fun6842 2 жыл бұрын
in this calculation ;it shows no value why..
@savadahmed2019
@savadahmed2019 2 жыл бұрын
Excellant sir.
@XLnCADMalayalam
@XLnCADMalayalam 2 жыл бұрын
Thank you :)
@pradeepclassicpradeepclass930
@pradeepclassicpradeepclass930 Жыл бұрын
Thank you sir 🙏
@rageshtg7226
@rageshtg7226 3 жыл бұрын
Nice.. Thanks
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Welcome 😊
@faisalk79
@faisalk79 2 жыл бұрын
In my cumpter If I enter same thing error shows
@kmanoj392
@kmanoj392 2 жыл бұрын
Good
@sujathalita1508
@sujathalita1508 2 жыл бұрын
I make it same formula in Overtime calculation report, but get it ### in PM to AM overtime calculation time, AM to PM its ok,but PM to AM its get wrong, formula is (If(out time > intime,out time-in time, out time-in time+1)
@George-ue8ph
@George-ue8ph Жыл бұрын
Same thing for me when I get practice 😔
@anu6072
@anu6072 3 жыл бұрын
Sap upayogichi engane exlilengane prudact order adikka upakaram avum
@SS-vb4dl
@SS-vb4dl 18 күн бұрын
ഒരു day 7 മണിക്കൂർ വർക് ചെയ്യണം, 7 il kooduthal work ചെയ്താലും 7 il Kurav ചെയ്താലും അത് എത്രയാണ് എന്ന് എങ്ങനെ ആണ് calculate cheyyunnath
@XLnCADMalayalam
@XLnCADMalayalam 8 күн бұрын
Check the following video. kzbin.info/www/bejne/pJbYnIiwg8x1rNUsi=CvLEcqGVwlwofhBM
@extmahi
@extmahi 3 жыл бұрын
Ithpole 5 employees nte 1 week timesheet pivot table ilot mattune engananu kanikamo please
@shabeelaboobacker352
@shabeelaboobacker352 3 жыл бұрын
ഞാൻ അജയ് എന്ന് പറഞ്ഞാൽ തന്നെ ധാരാളം.
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
അത് പൊളിച്ച് 😀 Thank you for that awesome compliment🙏
@prathapmv2777
@prathapmv2777 3 жыл бұрын
Nice Sir
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Thank you :)
@faisalk79
@faisalk79 2 жыл бұрын
When I am entering. Time as 8.00 am ( with am or pm) it is not coming
@pradeeppradeep4049
@pradeeppradeep4049 Жыл бұрын
ഇതിൽ 7am ഇന് ജോലിക്ക് കയറി 11pm വരെ എങ്ങനെ കൽകുലെട്ട് ചെയ്യും ഈ പറഞ്ഞ ഫോർമാറ്റ് വർക് ആകുന്നില്ല please reply
@rajithapa4844
@rajithapa4844 3 жыл бұрын
+1 കൊടുത്തതിന്റെ ലോജിക് ഒന്ന് explain ചെയ്യാമോ?
@prajithpp8787
@prajithpp8787 Жыл бұрын
ചില ദിവസങ്ങളിൽ വരാതിരികുമ്പോൾ aa colum blank ആകും എപ്പോൾ മുഴുവൻ calculate ചെയ്യാൻ പറ്റുന്നില്ല അത്#### ഇങ്ങനെ കാണിക്കുന്നു
@XLnCADMalayalam
@XLnCADMalayalam Жыл бұрын
Check my video on different type of Formula Errors in Excel. Cellswill display #### as result of insufficient Column Width.
@RETHEESHN
@RETHEESHN 3 жыл бұрын
Super
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Thank you :)
@jishnupm6444
@jishnupm6444 5 ай бұрын
Under time nte video indo
@XLnCADMalayalam
@XLnCADMalayalam 5 ай бұрын
Thank you for the suggestion.
@nishabudheen7554
@nishabudheen7554 2 жыл бұрын
Over time engane nokkum
@raeesbinsalam5362
@raeesbinsalam5362 Жыл бұрын
OT AMOUNT CALCULATION AS PER BASIC SALARY PLEAse
@saijusdiarysbysaijuvarghes5518
@saijusdiarysbysaijuvarghes5518 3 жыл бұрын
🤝
@manimumbaimumbai1961
@manimumbaimumbai1961 3 жыл бұрын
ഈ ഫോർമുല ms ഓഫീസ് 2013ഇൽ വർക്ക്‌ ചെയ്യുമോ?"Time diffrence"
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Yes.
@bilalyaseenvavasmuhemmed123
@bilalyaseenvavasmuhemmed123 3 жыл бұрын
👌👌👌👌
@vigneshvijayan8053
@vigneshvijayan8053 3 жыл бұрын
ഇതെന്താ #VALUE! ഇങ്ങനെ കാണിക്കുന്നേ
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Please refer my video on Formula Errors in Excel
@santhoshraj7333
@santhoshraj7333 3 жыл бұрын
Sir, stock maintenance video share it( purchase, sales, profit, included)
@abdurahimankuttypandiyalap9631
@abdurahimankuttypandiyalap9631 3 жыл бұрын
Super
@XLnCADMalayalam
@XLnCADMalayalam 3 жыл бұрын
Thank you :)
3 methods to Insert a Table from Excel to Word Document
7:01
XL n CAD Malayalam
Рет қаралды 28 М.
Most used Excel Formulas - Malayalam Tutorial
48:10
XL n CAD Malayalam
Рет қаралды 172 М.
ТЫ В ДЕТСТВЕ КОГДА ВЫПАЛ ЗУБ😂#shorts
00:59
BATEK_OFFICIAL
Рет қаралды 4,6 МЛН
How to Calculate Hours Worked in Excel
3:26
TEKNISHA
Рет қаралды 630 М.
Calculating Over Time & Regular Hours Microsoft EXCEL Malayalam Tutorial
8:17
Simple Time Sheet In Excel
12:06
EZ Learning
Рет қаралды 1,1 МЛН
IF Formula in Excel - Malayalam tutorial
14:32
XL n CAD Malayalam
Рет қаралды 28 М.
Excel: Create a Search Box in 3 Simple Steps!
5:34
NETVN82
Рет қаралды 342 М.
Pivot Table in Excel - Malayalam Tutorial
16:17
XL n CAD Malayalam
Рет қаралды 238 М.
How to use the Macro Recorder in Excel - Malayalam Tutorial
10:39
XL n CAD Malayalam
Рет қаралды 67 М.
Overtime Calculation (in Malayalam)
8:48
Naf Media
Рет қаралды 7 М.
Calculating Time in MS-Excel || Hindi
14:19
Deepak EduWorld
Рет қаралды 984 М.