Page 1 of 2 12 LastLast
Results 1 to 12 of 15

Thread: Help me

  1. #1
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Arrow Help me




    I want to insert time automatically in a cell but i don't want the time updated automatically...

    Let's say column A is a "Employee code" and column D is "Arrival Time".
    When i type Emp. code in cell A2, then the cell D2 should show automatically the time employee arrives.....
    And same for out time, File attached here.......
    Last edited by Rizwan Anjum; 28th March 2015 at 12:43 PM.

  2. #2
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

    Default

    آپ ایکسل کی وہ شیٹ اپلوڈ کریں جس پر آپ یہ کام کر نا چاہتے ہیں

  3. #3
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Arrow

    Quote Sahil_Jaan said: View Post
    آپ ایکسل کی وہ شیٹ اپلوڈ کریں جس پر آپ یہ کام کر نا چاہتے ہیں
    File attached here,,,,
    Attached Files Attached Files

  4. #4
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

    Default

    Quote rizwan anjum said: View Post


    file attached here,,,,
    اوکے ویٹ کریں چیک کرتا ہوں

  5. #5
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

    Default

    یہ کالم اس طرح بنے گے جب آپ ان ٹائم میں ٹائم لکھیں گے تو آوٹ ٹائم میں ٹائم اپڈیٹ ہو جائے گا
    چیک کرکے بتائیں اگر کوئی تبدیلی کرنی ہے تو وہ بھی بتا دیں
    test.xls

  6. #6
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Arrow

    Quote Sahil_Jaan said: View Post
    یہ کالم اس طرح بنے گے جب آپ ان ٹائم میں ٹائم لکھیں گے تو آوٹ ٹائم میں ٹائم اپڈیٹ ہو جائے گا
    چیک کرکے بتائیں اگر کوئی تبدیلی کرنی ہے تو وہ بھی بتا دیں
    test.xls
    Bhai shyed ap meri bat nehi samjhe.. emp cell mein jb code enter kro to us ka in time jo system ka ho wo auto feed ho jaye... out time ko ap chor dain...only in time chahye....For example: 08889 emp code hai.. pr system pr time 09:02 ha to in time k cell mein time auto show ho jaye, esi tarha next emp. jb aye to jo time system per ho wo show ho jaye, but previous time update na ho....

  7. #7
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Default

    help me please............

  8. #8
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

    Default

    Quote rizwan anjum said: View Post


    bhai shyed ap meri bat nehi samjhe.. Emp cell mein jb code enter kro to us ka in time jo system ka ho wo auto feed ho jaye... Out time ko ap chor dain...only in time chahye....for example: 08889 emp code hai.. Pr system pr time 09:02 ha to in time k cell mein time auto show ho jaye, esi tarha next emp. Jb aye to jo time system per ho wo show ho jaye, but previous time update na ho....
    یہ ویول بیسک سے ہو گا
    آپ یہ ٹو ٹوریل چیک کریں آپ کا مسئلہ حل ہو جائے گا

    CLOCK WITH AUTOMATIC REFRESH
    Last edited by Sahil_Jaan; 29th March 2015 at 05:01 PM.

  9. #9
    AsifSattarvi's Avatar
    AsifSattarvi is offline Advance Member
    Last Online
    12th October 2022 @ 02:54 PM
    Join Date
    20 May 2012
    Gender
    Male
    Posts
    6,594
    Threads
    104
    Credits
    30,058
    Thanked
    960

    Default

    آپ کونسا ایکسل استعمال کر رہے ہیں اس کے بارے میں بھی آگاہی دیں

  10. #10
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Arrow

    Quote AsifSattarvi said: View Post
    آپ کونسا ایکسل استعمال کر رہے ہیں اس کے بارے میں بھی آگاہی دیں
    Excel 2007

  11. #11
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Default

    Quote Sahil_Jaan said: View Post

    یہ ویول بیسک سے ہو گا
    آپ یہ ٹو ٹوریل چیک کریں آپ کا مسئلہ حل ہو جائے گا

    CLOCK WITH AUTOMATIC REFRESH
    Shyed ap meri bat nehi samjh rahe...

    Mujhe without automatic refresh chahye

  12. #12
    Adnanxyz's Avatar
    Adnanxyz is offline Senior Member+
    Last Online
    29th June 2017 @ 10:04 AM
    Join Date
    28 May 2014
    Age
    38
    Gender
    Male
    Posts
    413
    Threads
    17
    Credits
    214
    Thanked
    27

Page 1 of 2 12 LastLast

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
  •