Results 1 to 9 of 9

Thread: I need Formula in Excel of dates ???

  1. #1
    adnanbahrian is offline Advance Member
    Last Online
    29th May 2023 @ 08:21 PM
    Join Date
    08 Aug 2007
    Location
    Karachi
    Age
    41
    Gender
    Male
    Posts
    1,238
    Threads
    421
    Credits
    317
    Thanked
    63

    Default I need Formula in Excel of dates ???

    kia koi mughay formula bata sacta hay dates conversion ka jaisay : 7th day ko 03:30 mayn say 06th , 13:06 minus karna hay in excel like ,

    date hr mins
    07 03 30
    06 13 06
    ---------------
    00 14 24 ( its ans )

    is ka koi formula bata sacta hay ???? plz

  2. #2
    habibrahet's Avatar
    habibrahet is offline Advance Member
    Last Online
    25th August 2021 @ 02:33 PM
    Join Date
    30 Nov 2008
    Location
    PaKisTaN
    Gender
    Male
    Posts
    2,041
    Threads
    140
    Credits
    69
    Thanked
    102

    Default

    Quote adnanbahrian said: View Post
    kia koi mughay formula bata sacta hay dates conversion ka jaisay : 7th day ko 03:30 mayn say 06th , 13:06 minus karna hay in excel like ,

    date hr mins
    07 03 30
    06 13 06
    ---------------
    00 14 24 ( its ans )

    is ka koi formula bata sacta hay ???? plz
    aap ko waqai iss farmulay ki ashad zaroorat hay.

    chalen kuch kartay hain ap kay liay/
    The Race Is Not Over, Coz I've Not Won Yet.



  3. #3
    habibrahet's Avatar
    habibrahet is offline Advance Member
    Last Online
    25th August 2021 @ 02:33 PM
    Join Date
    30 Nov 2008
    Location
    PaKisTaN
    Gender
    Male
    Posts
    2,041
    Threads
    140
    Credits
    69
    Thanked
    102

    Default


  4. #4
    habibrahet's Avatar
    habibrahet is offline Advance Member
    Last Online
    25th August 2021 @ 02:33 PM
    Join Date
    30 Nov 2008
    Location
    PaKisTaN
    Gender
    Male
    Posts
    2,041
    Threads
    140
    Credits
    69
    Thanked
    102

    Default


  5. #5
    Join Date
    05 Dec 2008
    Location
    MA K Qadmo Taly
    Gender
    Male
    Posts
    5,557
    Threads
    52
    Credits
    1,368
    Thanked
    261

    Default

    Quote habibrahet said: View Post
    nice information

  6. #6
    AdeelDx's Avatar
    AdeelDx is offline Senior Member+
    Last Online
    29th November 2013 @ 01:52 PM
    Join Date
    17 Aug 2008
    Location
    ~*~ITD~*~
    Posts
    2,215
    Threads
    23
    Credits
    945
    Thanked
    4

    Default

    Dear excel me date maloom karnay ka formula yeh hai. Blank cell par ja kar yeh code likho. =now()

  7. #7
    ilyas322's Avatar
    ilyas322 is offline Senior Member+
    Last Online
    23rd December 2009 @ 11:57 AM
    Join Date
    11 Apr 2007
    Location
    Naseera, Punjab, Pakistan
    Age
    38
    Posts
    224
    Threads
    10
    Credits
    0
    Thanked
    2

    Default

    nice sharing janab.
    thnx

  8. #8
    adnanbahrian is offline Advance Member
    Last Online
    29th May 2023 @ 08:21 PM
    Join Date
    08 Aug 2007
    Location
    Karachi
    Age
    41
    Gender
    Male
    Posts
    1,238
    Threads
    421
    Credits
    317
    Thanked
    63

    Default

    thanks a lo t let me check...

  9. #9
    habibrahet's Avatar
    habibrahet is offline Advance Member
    Last Online
    25th August 2021 @ 02:33 PM
    Join Date
    30 Nov 2008
    Location
    PaKisTaN
    Gender
    Male
    Posts
    2,041
    Threads
    140
    Credits
    69
    Thanked
    102

    Default

    Quote adnanbahrian said: View Post
    thanks a lo t let me check...
    zaroor

    tassali kar leejiay

    bus itna khayal rakhiay ga entry kay waqt kay entry kaisay karni hay, ager aap nay pattern change kiya to ghalti ho sakti hay. is liay patern 1 jesa he rakhiay ga, jahan tak aap nay sum ki range dee ho gi.

    mm(dash)dd(dash)yyyy(space)hr(colun)mn(enter)

    where
    mm=month
    dd= date
    yyyy=year
    hr=hour
    mn=minute

    date or time kay darmayan space dena hay.
    date main shayed (slash) bhee kaam kar lay, check kar leejiay ga.

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. need excel formula
    By hassankarim in forum Ask an Expert
    Replies: 7
    Last Post: 28th June 2015, 05:12 AM
  3. Need help in excel formula
    By zaidi91 in forum Ask an Expert
    Replies: 0
    Last Post: 23rd February 2015, 01:08 PM
  4. Solved Excel Formula
    By mohsinyounis in forum Solved Problems (IT)
    Replies: 20
    Last Post: 14th March 2011, 11:14 AM
  5. excel formula ??
    By adnanbahrian in forum Ask an Expert
    Replies: 5
    Last Post: 22nd February 2009, 11:06 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
  •