Results 1 to 3 of 3

Thread: excel complet formula wanted

  1. #1
    hardduty's Avatar
    hardduty is offline Advance Member
    Last Online
    7th June 2023 @ 12:17 AM
    Join Date
    14 Feb 2011
    Age
    35
    Gender
    Male
    Posts
    759
    Threads
    282
    Credits
    3,037
    Thanked
    11

    Default excel complet formula wanted

    ASSLAM O ALIKUM
    SIR
    KINDLY GIVE ME SOME EXCEL FORMULA
    1 +-*/ AND PERSENTAGE %
    AND OTHER IS
    and conditional formula

    menu function formula
    apply format
    LIKE A SAMATION SIGN PLUS HO JATA ISEE TERHA MINUS KERNA KON SA FORMULA LAGIAN GA
    OR MULTIPLY 1 CLICK PER HO JIAYA
    KINDLY GIVE ME SOME FORMATE EXCEL ACCORDING
    TO ESSILY UNDERSTOOD

  2. #2
    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.

  3. #3
    syedmahramali is offline Junior Member
    Last Online
    29th July 2018 @ 10:16 PM
    Join Date
    29 Jul 2018
    Gender
    Male
    Posts
    1
    Threads
    0
    Credits
    114
    Thanked
    0

    Default

    kindly koi hay yahan jo mujhe salary ke auto formulas batae

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. Complet Quran pak mp3 format ma wanted
    By hardduty in forum Ask an Expert
    Replies: 9
    Last Post: 24th June 2013, 02:18 PM
  3. Excel Formula Help
    By adnanmomin in forum Ask an Expert
    Replies: 4
    Last Post: 31st May 2013, 06:38 PM
  4. I need formula in excel
    By adnanbahrian in forum Ask an Expert
    Replies: 13
    Last Post: 22nd April 2010, 06:24 PM
  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
  •