Results 1 to 4 of 4

Thread: Excel Expert Help Plz

  1. #1
    Shahid R's Avatar
    Shahid R is offline Senior Member+
    Last Online
    4th December 2021 @ 03:02 PM
    Join Date
    26 Jan 2012
    Gender
    Male
    Posts
    251
    Threads
    25
    Credits
    1,336
    Thanked
    4

    Default Excel Expert Help Plz

    Salam
    Mujy excel ka 1 formula chahiye
    1 raqam hai 100.246
    Is me se 100 automaticaly minus ho jaye aur .246 agy cell me ajaye jahan formula lagayen
    TWEETER ID @DISH_FTA

  2. #2
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    =A2-TRUNC((A2))

  3. #3
    nsb_art is offline Junior Member
    Last Online
    19th December 2017 @ 12:12 PM
    Join Date
    04 Jun 2017
    Gender
    Male
    Posts
    6
    Threads
    0
    Credits
    58
    Thanked
    0

    Default

    There are 3 shifts, Every shift needs change duty after a Week (Sunday) of the month through 24:00 hrs. as given below detail.

    Date: Friday,01/12/2017
    Shift:A 00:00 TO 08:00 hrs (Night-duty)
    Shift:B 08:00 TO 16:00 hrs (Morning-duty)
    Shift:C 16:00 TO 24:00 hrs (Evening-duty)

    Date: Saturday,02/12/2017
    Shift:A 00:00 TO 08:00 hrs (Night-duty)
    Shift:B 08:00 TO 16:00 hrs (Morning-duty)
    Shift:C 16:00 TO 24:00 hrs (Evening-duty)

    Date: Sunday,03/12/2017
    Shift:A 00:00 TO 08:00 hrs (Night-duty)
    Shift:B 08:00 TO 16:00 hrs (Morning-duty)
    Shift:C 16:00 TO 24:00 hrs (Evening-duty)

    Date: Monday,04/12/2017 (Duty Shift would be Changed)
    Shift:A 16:00 TO 24:00 hrs (Evening-duty)
    Shift:B 00:00 TO 08:00 hrs (Night-duty)
    Shift:C 08:00 TO 16:00 hrs (Morning-duty)

    Please help me that how to set formula in excel that will show me Shifts: A, B or C will perform their duties on given date in 24:00 hrs.

    - - - Updated - - -

    There are 3 shifts, Every shift needs change duty after a Week (Sunday) of the month through 24:00 hrs. as given below detail.

    Date: Friday,01/12/2017
    Shift:A 00:00 TO 08:00 hrs (Night-duty)
    Shift:B 08:00 TO 16:00 hrs (Morning-duty)
    Shift:C 16:00 TO 24:00 hrs (Evening-duty)

    Date: Saturday,02/12/2017
    Shift:A 00:00 TO 08:00 hrs (Night-duty)
    Shift:B 08:00 TO 16:00 hrs (Morning-duty)
    Shift:C 16:00 TO 24:00 hrs (Evening-duty)

    Date: Sunday,03/12/2017
    Shift:A 00:00 TO 08:00 hrs (Night-duty)
    Shift:B 08:00 TO 16:00 hrs (Morning-duty)
    Shift:C 16:00 TO 24:00 hrs (Evening-duty)

    Date: Monday,04/12/2017 (Duty Shift would be Changed)
    Shift:A 16:00 TO 24:00 hrs (Evening-duty)
    Shift:B 00:00 TO 08:00 hrs (Night-duty)
    Shift:C 08:00 TO 16:00 hrs (Morning-duty)

    Please help me that how to set formula in excel that will show me Shifts: A, B or C will perform their duties on given date in 24:00 hrs.

  4. #4
    nsb_art is offline Junior Member
    Last Online
    19th December 2017 @ 12:12 PM
    Join Date
    04 Jun 2017
    Gender
    Male
    Posts
    6
    Threads
    0
    Credits
    58
    Thanked
    0

    Default how to set SUM formula in excel

    Hello guys,

    I have need a help to you please. as given below task.

    Sum 1st date:
    Today figure 4
    To Month 4
    To Year = 4

    Sum 2nd date:
    Today figure 2
    To Month 6
    To Year = 6

    Sum 3rd date:
    Today figure 0
    To Month 6
    To Year = 6

    Now, My last Yearly figure remain same as I plus or minus figure in today's figure. it may go auto sum upto date. please tell me formula or condition for that. In advance thanks.

Similar Threads

  1. Koi excel ka expert hai yeh
    By Sincere778 in forum Ask an Expert
    Replies: 1
    Last Post: 21st October 2017, 12:47 PM
  2. Koi ms excel expert hay?
    By sanafaiz in forum Ask an Expert
    Replies: 1
    Last Post: 20th February 2014, 04:18 PM
  3. MS Excel Expert plz help me
    By Syed Hamid Ali in forum Ask an Expert
    Replies: 6
    Last Post: 19th October 2012, 11:22 AM
  4. Excel Expert Plz Help?????????
    By Stanha1989 in forum Ask an Expert
    Replies: 4
    Last Post: 27th November 2011, 04:20 PM
  5. Help - Excel Expert
    By Nadeem Ahmed Kh in forum Ask an Expert
    Replies: 3
    Last Post: 9th November 2009, 01:53 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
  •