Results 1 to 6 of 6

Thread: ExCEL MEIN TIME NIKALNA

  1. #1
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default ExCEL MEIN TIME NIKALNA


    کوئی ایکسل ایکسپرٹ میری اس شیٹ میں ٹوٹل ٹائم کا فارمولھ لگانے کا طریقھ بتا دے۔
    Attached Files Attached Files

  2. #2
    Jaffary is offline Senior Member+
    Last Online
    23rd May 2021 @ 01:04 PM
    Join Date
    06 Mar 2009
    Age
    48
    Posts
    336
    Threads
    11
    Credits
    1,252
    Thanked
    4

    Default Re: ExCEL MEIN TIME NIKALNA

    Dear


    aap ki file main aap ki zarorat k mutabiq changes kardi hai.
    File download karlain, Umeed hy ky aapka kaam hojaye ga.

    neechey tareeqa likha hy, agar kuch samajh main na aaye tou pooch lain.

    1. data likhney ka format change karna ho ga.
    jahan sy tabdeel hota hy os ka Snapshot bhi laga dia hy.

    2. time ko proper format main likhain. jaisey : hh:mm:ss AM/PM


    Shukria,
    Jaffary
    Attached Files Attached Files

  3. #3
    iffi_nice is offline Junior Member
    Last Online
    2nd June 2019 @ 09:08 AM
    Join Date
    05 Aug 2009
    Location
    Dubai
    Gender
    Male
    Posts
    25
    Threads
    1
    Credits
    60
    Thanked: 1

    Default وقت


    سب سے پہلے آپ سي اور ڈي کالم کي سيٹنگ ٹائم کريں۔ دونوں کالم کو سيلٹک کر کے سيدھا مائوس دبائيں پھر ٹائم سيلکٹ کريں پھر يہ فارمولا استعمال کريں اي کالم ميں:
    =TEXT(H5-G5; "h:mm")

  4. #4
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default

    Jaffary bhai Aap Ne Jo Sheet Mein Farmula Lagaiya Hai Wo Tu Bohat Se Cells Mein Apply Nahi Ho Raha. ye ###### ban jata.

    Or Iffi Bhai Aap Ka Ye Farmula Kaam nahi kr Raha.
    Plz Koch Aur Btain

  5. #5
    syar is offline Advance Member
    Last Online
    3rd April 2024 @ 04:29 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    884
    Threads
    9
    Credits
    563
    Thanked
    340

    Default

    Quote Arshad2579 said: View Post
    Jaffary bhai Aap Ne Jo Sheet Mein Farmula Lagaiya Hai Wo Tu Bohat Se Cells Mein Apply Nahi Ho Raha. ye ###### ban jata.

    Or Iffi Bhai Aap Ka Ye Farmula Kaam nahi kr Raha.
    Plz Koch Aur Btain


    Apne Cell ki format Propoer Time k rakhain. Ya AM/PM lekhte hue ak space dain aap ka masla hal ho jae ga.

    phir E5 m below formula lagain aur copy down as far as required

    Code:
    =IF(D5>C5,D5-C5,(D5+12)-C5)
    regards,

  6. #6
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default

    بہت بہت شکریہ
    Sir!
    یہ فارمولھ بالکل درست کام کر رھا ہے۔
    Problam Solved

Similar Threads

  1. Solved Ms Excel Mein Custom Quma(,) Lagana
    By Arshad2579 in forum Solved Problems (IT)
    Replies: 7
    Last Post: 30th July 2012, 08:04 PM
  2. Telenor Message Timing problem
    By sanafaiz in forum Mobile phones problems and Help Zone
    Replies: 5
    Last Post: 11th January 2010, 06:57 PM
  3. Replies: 13
    Last Post: 23rd October 2009, 09:41 AM
  4. Excel file mey Auto time adjust karna
    By Habib in forum Ask an Expert
    Replies: 4
    Last Post: 16th December 2006, 03:58 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •