Date and Time Function in Excel in Tamil

Поділитися
Вставка
  • Опубліковано 30 жов 2024

КОМЕНТАРІ • 129

  • @sayishvasanth1146
    @sayishvasanth1146 3 роки тому +9

    This is the best channel for excel in tamil .The method of teaching is very clear.Well done bro.👍

  • @madhumathishanmugam9438
    @madhumathishanmugam9438 3 роки тому +7

    Bro, unga explanation clear cut... Please upload many things.. Keep doing bro.

  • @gayuaurora742
    @gayuaurora742 2 роки тому +3

    Your teaching is crisp and neat and i like it ✨ just perfect keep going ✨

    • @EndlessKnowledge
      @EndlessKnowledge  2 роки тому

      Thanks and i will... Keep learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @thaiyalnayagi2397
    @thaiyalnayagi2397 3 роки тому +4

    Your explanation to every concept looks clean and clear in all your videos that I saw. Excellent

  • @poojamanohar2016
    @poojamanohar2016 3 роки тому

    Your chenal is one of the best chenal sir, please explain the "short cut keys of date format"

  • @saikishore1961
    @saikishore1961 3 роки тому

    Sir your video is so much helpful to me thank you. Sir negha upload pana excel videos oru sequence la irundha enghala polla beginners ku useful ah irukom easy ah step by step kathuka .

  • @priyaravi4089
    @priyaravi4089 Рік тому

    Your voice is very good. Thanks

  • @baskaranvaradhan2369
    @baskaranvaradhan2369 3 роки тому +1

    As usual super thank you 🙏

  • @mohamedyazar8755
    @mohamedyazar8755 3 роки тому +1

    Dear sir please put videos for production graph chart pie chart preparation your videos is amazing 👍

  • @ramnishadkuttuva9306
    @ramnishadkuttuva9306 3 роки тому

    very interesting and good explanation with examples . have tried now expecting next 10 functions soon

  • @vincentpaul8533
    @vincentpaul8533 3 роки тому

    Thank you very much Sir.

  • @ramakrishnanm5817
    @ramakrishnanm5817 3 роки тому

    Super bro very useful

  • @akshayasowyanarayan5521
    @akshayasowyanarayan5521 7 місяців тому

    Nice explanation

  • @sasidharan63
    @sasidharan63 2 роки тому

    Super video

  • @venkatesann4799
    @venkatesann4799 2 роки тому

    Very nice sir

  • @balajikumar7683
    @balajikumar7683 3 роки тому

    Bro very good and useful video endless knowledge is endless rocking pls go ahead kindly make a video on how to change tamil language in ms word when i type tamil words it is not changing in tamil or we need to install any tamil software pls guide me how to enter tamil words in ms word if u tell it will be very helpful

  • @sivasankar7077
    @sivasankar7077 3 роки тому

    Very useful video ❤️, make more videos please advance excel

  • @shyamala.r1575
    @shyamala.r1575 2 роки тому

    Thank you bro..

  • @yuvaraj3696
    @yuvaraj3696 3 роки тому

    Nice explanation sir👍👍

  • @tamilliva8883
    @tamilliva8883 2 роки тому

    Super bro

  • @immanuelraj3037
    @immanuelraj3037 3 роки тому +1

    Thank you so much.

  • @sivama7824
    @sivama7824 3 роки тому +2

    Thank You 😊

    • @EndlessKnowledge
      @EndlessKnowledge  3 роки тому +1

      You're welcome 😊

    • @amtecs8420
      @amtecs8420 Рік тому

      Sir. D. O. B.(01/01/1966)To 60 yrs Retirement date how to calculate pl help.

  • @magaraja8679
    @magaraja8679 Рік тому

    Really amazing

  • @digitalstudyz
    @digitalstudyz 3 роки тому

    Thanks

  • @vaishali1739
    @vaishali1739 3 роки тому

    Theivame itha video than rompa naal ah theditu iruken

  • @jeykar2317
    @jeykar2317 3 роки тому

    Very very useful dude👌👌👌teaching gud 👍 keep going 😊

  • @lakshmia5053
    @lakshmia5053 3 роки тому

    Hello bro very nice content 🤗

  • @saroprabu
    @saroprabu 3 роки тому

    Nice info bro thanks...👍..but intha formula athigama entha subject ku use agum bro...

    • @EndlessKnowledge
      @EndlessKnowledge  3 роки тому

      like attendance, units working time calculations...etc.

  • @tangamtamil
    @tangamtamil 3 роки тому +1

    Current date - Ctrl + ;
    Current time - Ctrl + :

  • @sribavna756
    @sribavna756 Рік тому

    thankyou

  • @sayishvasanth1146
    @sayishvasanth1146 3 роки тому +2

    Bro...when copy pasting cells, some cells got missed out after pasting. Why?can u pls help with answer

  • @NuskyMuhammadh
    @NuskyMuhammadh 2 роки тому +1

    Hi sir

  • @ragak3354
    @ragak3354 11 місяців тому

    Super

    • @EndlessKnowledge
      @EndlessKnowledge  11 місяців тому

      Thanks... Keep learning more about excel important functions ua-cam.com/play/PLLHRrAfRqTbOsdHa6irHBfNexiVaPmwJa.html

  • @adarshgodson3015
    @adarshgodson3015 3 роки тому

    Keep rocking bro

  • @AKQueenAKQueen
    @AKQueenAKQueen 3 роки тому

    Pakka Sir.. 🔥...

  • @p.m.kadernainarsait8687
    @p.m.kadernainarsait8687 9 місяців тому

    Is there is any formula to fill dates with in the month from 1~30 except holidays (like working schedule plan date )

  • @piriyatharsinithillainadarajah

    How to create two years difference month calculation.? . please send answer . thanks to you

  • @chidambaramr5176
    @chidambaramr5176 2 роки тому

    The formula, =Datedif(SD,ED,"Y") returns age when the date is less than 15 but returns "values" when the date is greater than 15.

  • @muthuraj9403
    @muthuraj9403 4 місяці тому

    Sir oru date la irundhu no of installment add pannum pothu endha date la installment mudiyum nu output varanum epdinga sir
    For example 01.06.2006 + 120 installment
    pls clear pannunga sir

  • @prithu2927
    @prithu2927 3 роки тому

    Bro oru day kuduthu athooda day eppadi kandupidikanum
    My question is
    Find the date on which next Sunday falls.

  • @Kuchi_ice_offl
    @Kuchi_ice_offl 9 місяців тому

    Shorts video LA kuduthurukka song and video namma video kku use pannalaamaa?

  • @selvaraj-jy7ud
    @selvaraj-jy7ud 3 роки тому

    Thank u sir..... தேதியை constant da vaichukidu month mattum marukira Mathiru oru 180 months ku table eppadi create pannuvathu?

  • @mohamedyusuf4410
    @mohamedyusuf4410 3 роки тому

    Nice bro

  • @rajasekarv2517
    @rajasekarv2517 3 роки тому

    Please bro continue the photoshop tutorial

  • @akash.i7391
    @akash.i7391 2 місяці тому

    Sir.. I use datevalue and time value function in the cell. But i didn't get any number.. It gives a value error.. What should I do for that error.?

  • @vijayvj6774
    @vijayvj6774 3 роки тому

    Hii... Sir
    Small problem
    IPO Nov-2020nu irukku 18th months calculated Panna varumaa sir .

  • @bharaththangavel
    @bharaththangavel 3 роки тому

    Anna if Basic Computer course is valid for government jobs?

  • @maheshvenkatesan617
    @maheshvenkatesan617 Рік тому

    Sir, need to add same date and month but years mattum change agaanum.. means 20/06/2023 next 20/06/2024 .....need like this up to 50 years..pls help on this

  • @living640
    @living640 Рік тому

    Sir,
    6 am to 2am eppadi calculate pantrathu konjam sollunga

  • @manjulasrinivasan4428
    @manjulasrinivasan4428 3 роки тому

    Sir eppadi Google forms create pandradh..plz video poduga

  • @piriyatharsinithillainadarajah

    Eg 06.10.2022, 06.09.2021 difference furmala please. Thanks to you.

  • @marimuthu-ky9xl
    @marimuthu-ky9xl Рік тому

    Video explains pannuga sir

    • @EndlessKnowledge
      @EndlessKnowledge  Рік тому

      Sure... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @RamKumar-gs3tz
    @RamKumar-gs3tz Місяць тому

    hello sir
    date/month/year format
    how to change
    month/date/year format.
    my office SAP report always come dd/mm/yy format

  • @DHANARAJ_IYYAPPAN
    @DHANARAJ_IYYAPPAN 2 роки тому

    Bro Daily naan oru sheet create pannanum one month ku one book
    So enakku date change aaga koodaathu bro adhukku formula irukkaaa bro

  • @chitrakarthik696
    @chitrakarthik696 10 місяців тому

    ❤love 💖 you❤

  • @hariprasath-ob3kj
    @hariprasath-ob3kj 3 роки тому

    Dude presently I am using excell old version. Hw to update excell latest version.. kindly help me. Waiting for ur reply..

  • @prabhuprabhu-cr3tz
    @prabhuprabhu-cr3tz 3 роки тому +1

    Sir ippo enaku 4th oct nu excel la varanum eppidinu solunga.

  • @dhamodaraninbanathan3592
    @dhamodaraninbanathan3592 2 роки тому +1

    How to enable CONSOLIDATE function in excel Ribnon?

  • @sudalkumarr7237
    @sudalkumarr7237 2 роки тому

    How to sort when data is day, month, date, year. Example Sunday, July 10, 2022

  • @sakthimassda
    @sakthimassda Рік тому

    Bro January la moththama 31 days thana ana etha pottu pakkum pothu 30 days than kattuthu bro

  • @premkumar-jq1xr
    @premkumar-jq1xr Рік тому

    How to convert number to hour[ 81522- 8:15:22 AM ]because infornt of zero not available.

  • @priyangam989
    @priyangam989 2 роки тому

    Sir., datevalue &time value wotkout aagala sir yen nu konjam sollunga sir..

  • @SenthilKumar-sl8he
    @SenthilKumar-sl8he 10 місяців тому

    Sir one dout excel 2007 datevalue work aka matuthuthu ena panala

  • @umeshr7923
    @umeshr7923 3 роки тому +1

    How to fill the date continuously

  • @dhuraipandi4499
    @dhuraipandi4499 3 роки тому

    Bro date&time function pc date ahh output kudukkuma illa,present date&time ahh kudukkuma

  • @vasanthsathiyanarayanan8026
    @vasanthsathiyanarayanan8026 3 роки тому

    From today date I need what is after next 30 days date how to write formupa

  • @jameelasubahan1345
    @jameelasubahan1345 3 місяці тому

    Ithu yn bro vera work sheet la pna wrk ava matudhu value nu error varuthu

  • @Seegameover
    @Seegameover 3 роки тому

    Bro idha date and time simple data entry form la yeppadi insert panuradhu..plz solluga ji

  • @data_analyst157
    @data_analyst157 Рік тому +1

    Excel 2010 la potta formula varala error varuthu

  • @dhamodaraninbanathan3592
    @dhamodaraninbanathan3592 2 роки тому +1

    Bro how to convert from "seconds" to "hour" ?

  • @antonyrajy5388
    @antonyrajy5388 Рік тому

    Auto update formula

  • @adhirudhyas2998
    @adhirudhyas2998 3 роки тому

    How to set up date and time live timmer in excell

  • @saiprasadvittal
    @saiprasadvittal Рік тому

    Tell me what is Date and time shortcut key

    • @EndlessKnowledge
      @EndlessKnowledge  Рік тому

      Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).

    • @saiprasadvittal
      @saiprasadvittal Рік тому

      @@EndlessKnowledge Thank-you

  • @kalyanaraman22
    @kalyanaraman22 Рік тому

    Sir good morning. Excel sheet calculation doubt. Please help me. Below details:
    A column:- date
    B column:- Bill no.
    C Column:- Taxable value
    D Column:- Tax Rate
    E column:- Cgst
    F column:- Sgst
    G column:- Total
    A column B column
    01.08.22. 01
    02.08.22. 02
    02.08.22. 02
    02.08.22 02
    02.08.22. 02
    03.08.22. 03
    03.08.22. 03
    03.08.22. 03
    04.08.22. 04
    04.08.22. 04
    C - value D - Tax Rate
    1000. 18
    3440. 12
    2340. 18
    2000. 18
    4300. 18
    3000. 5
    3590. 12
    5000. 28
    1600. 18
    9410. 12
    E-chst. F-sgst
    200. 200
    200. 200
    200. 200
    200. 200
    200. 200
    200. 200
    200. 200
    200. 200
    200. 200
    200. 200
    G- Total
    1400
    3840
    2740
    2400
    4700
    3400
    3990
    5400
    2000
    9810

  • @sathyat4601
    @sathyat4601 3 роки тому

    How to change date / to . In excel

  • @basumanvijay7365
    @basumanvijay7365 2 роки тому

    Arrival time 1000hrs
    Should be Ready say : 1030hrs
    But one person came 1015hrs and one person came 1040hrs
    Result will be come arrived 1015 - Nil and late arrived person result will be come 10minutes
    Kindly advise which formula will be come

  • @devadevaraj8441
    @devadevaraj8441 Рік тому

    Mobile- ல் Useபன்னுவது எப்படி ?Sir..

    • @EndlessKnowledge
      @EndlessKnowledge  Рік тому

      will try to upload a dedicated video regarding this... Keep Learning more about Excel ua-cam.com/play/PLLHRrAfRqTbPlRR5PUNp7clxJ9N7uUpfh.html

  • @murugiahsvpr
    @murugiahsvpr 3 роки тому

    சார் முதலில் உங்களுக்கு நன்றி சொல்லிக்கொள்கிறேன் ஏன் என்றால் உங்கள் வீடியோ பார்த்து நிறைய கற்றுக்கொண்டேன்.
    அப்புறம் சார் ஒரு சந்தேகம்
    குறிப்பிட்ட இரண்டு நேரங்களுக்கு இடையே நடந்த விபரங்களை countif பண்ண முடியுமா?

    • @EndlessKnowledge
      @EndlessKnowledge  3 роки тому

      yes nanba... but use countifs combined with date function...

    • @murugiahsvpr
      @murugiahsvpr 3 роки тому

      @@EndlessKnowledge நன்றி.
      நான் எதிர்பார்க்கவில்லை பதில் வரும் என்று. மீண்டும் நன்றி

  • @jesus-jx5hd
    @jesus-jx5hd 3 роки тому

    Date value is not working for me

  • @kalyanaraman22
    @kalyanaraman22 Рік тому

    Sir good morning. Excel sheet calculation doubt. Please help me. Below details:
    A column:- date
    B column:- Bill no.
    C Column:- Taxable value
    D Column:- Tax Rate
    E column:- Igst
    F column:- Total
    A column B column
    01.08.22. 01
    02.08.22. 02
    02.08.22. 02
    02.08.22 02
    02.08.22. 02
    03.08.22. 03
    03.08.22. 03
    03.08.22. 03
    04.08.22. 04
    04.08.22. 04
    C - value D - Tax Rate
    1000. 18
    3440. 12
    2340. 18
    2000. 18
    4300. 18
    3000. 5
    3590. 12
    5000. 28
    1600. 18
    9410. 12
    E-Igst. G- Total
    400. 1400
    400. 3840
    400. 2740
    400. 2400
    400. 4700
    400. 3400
    400. 3990
    400. 5400
    400. 2000
    400. 9810

  • @-the99shorts
    @-the99shorts 3 роки тому

    Photo shop basicla irunthu fulla exal mathri sainga pls
    I am from sri Lanka pls replay me

    • @EndlessKnowledge
      @EndlessKnowledge  3 роки тому

      kindly check this nanba ua-cam.com/play/PLLHRrAfRqTbMnCd0CUBI4Gfq1Ru2hVeJe.html

  • @moviesdownload462
    @moviesdownload462 Рік тому

    ctrl + shift+ 7 not working

  • @myhappiness-q7i
    @myhappiness-q7i 3 роки тому

    Anna current time a add panni athu yappavum change aagama iruka yethum formula iruka?

  • @raahathcabs7305
    @raahathcabs7305 3 роки тому

    DAYS FUNCTION NOT WORKING
    #NAME?

  • @skrsaratha5000
    @skrsaratha5000 2 роки тому

    ஒரு மாதம் இருக்கிறது என்றால் அந்த மாதத்தில் மொத்த நாட்கள் எத்தனை என்பது எவ்வாறு கண்டுபிடிக்கலாம்

    • @skff8802
      @skff8802 2 місяці тому

      @@skrsaratha5000 calender eduthu paruga

  • @vickyvikranth13
    @vickyvikranth13 3 роки тому

    Sir very nice..... Sir unga no please..

  • @mohammedshameelv74
    @mohammedshameelv74 3 роки тому

    Thank you very much

  • @vijaykumar-vo8ib
    @vijaykumar-vo8ib 3 роки тому

    Thanks