Results 1 to 4 of 4

Thread: Excel me time kese gataye

  1. #1
    Nadeem Ahmed Kh's Avatar
    Nadeem Ahmed Kh is offline Senior Member+
    Last Online
    19th September 2015 @ 10:32 AM
    Join Date
    10 Apr 2009
    Location
    New Delhi
    Gender
    Male
    Posts
    655
    Threads
    115
    Credits
    1,000
    Thanked
    31

    Default Excel me time kese gataye



    Agar 10:30 AM me se 11:30 AM minus kare to esko excel me kese (formula ke tahat) ghatayege ya 10:30 AM me se 11:30 PM ko, koi formula to hoga hi, marbani kar ke mujhko ye bataye.


    Sukriya

  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    Time minus ya difference maloom karne k leye koi special formula tu nahee hota except some special cases. Leekan aap k case m sirf aap ko simple minus k formula lagana ho ga.
    suppose 10:30 cell a1 m aur 11:30 cell b1 m. Formula =a1-b1.

    But ye aap ko ####### k error de ga. Ye formula is sorat m kam karega k aap
    tool=====>option====>calculation k Tab m ja kar "Use 1904 date system""
    ko chek kar dain aap ka masla hal ho jae ga.

    Regards

  3. #3
    Sohailattari is offline Junior Member
    Last Online
    14th November 2015 @ 01:14 AM
    Join Date
    22 May 2007
    Age
    51
    Posts
    12
    Threads
    5
    Credits
    0
    Thanked
    0

    Default Dozen convert in Pieces


    please help me for this function

    Mujhe aik formula chaiye jo ke hai 3.6 or 3-6 is ko convert karna hai pieces mai.

    THank you.
    Attached Files Attached Files
    Last edited by Sohailattari; 26th November 2009 at 10:04 AM.

  4. #4
    Sohailattari is offline Junior Member
    Last Online
    14th November 2015 @ 01:14 AM
    Join Date
    22 May 2007
    Age
    51
    Posts
    12
    Threads
    5
    Credits
    0
    Thanked
    0

    Default convert karna hai pieces.

    Hurry up please help me for this function

    Mujhe aik formula chaiye jo ke hai 3.6 or 3-6 is ko convert karna hai pieces mai.I will be thankful for this.

    Attached Files Attached Files

Similar Threads

  1. World Time In Excel Sheet
    By Shehzad Iqbal in forum General Discussion
    Replies: 25
    Last Post: 2nd April 2015, 05:09 AM
  2. ExCEL MEIN TIME NIKALNA
    By Arshad2579 in forum Ask an Expert
    Replies: 5
    Last Post: 25th November 2012, 08:53 PM
  3. Solved Excel Time Farmula Help
    By Shireen Shari in forum Solved Problems (IT)
    Replies: 8
    Last Post: 27th January 2012, 09:40 PM
  4. Solved Time Farmula in Excel
    By Shireen Shari in forum Solved Problems (IT)
    Replies: 24
    Last Post: 14th December 2011, 07:54 PM
  5. How to Calculate Time in Excel Sheet ???
    By Baazigar in forum Solved Problems (IT)
    Replies: 7
    Last Post: 20th July 2010, 09:33 PM

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
  •