Results 1 to 5 of 5

Thread: Formula in Excel Sheet

  1. #1
    zahid4942's Avatar
    zahid4942 is offline Senior Member+
    Last Online
    4th August 2022 @ 03:46 PM
    Join Date
    20 Mar 2010
    Location
    korangi
    Gender
    Male
    Posts
    469
    Threads
    120
    Credits
    1,478
    Thanked
    18

    Default Formula in Excel Sheet

    helo doston,

    may aik sheet ready kar raha hn jis may Over Time calculate ka formula lagana hay. par mujhe samajh nhy aa raha. koi dost hay jo ye formula laga sake. may file upload kar raha hn.
    Attached Files Attached Files

  2. #2
    Join Date
    11 Jan 2012
    Location
    Pakistan
    Age
    28
    Gender
    Male
    Posts
    865
    Threads
    60
    Credits
    5
    Thanked
    92

    Default

    nice

  3. #3
    Help4everyone's Avatar
    Help4everyone is offline Advance Member
    Last Online
    21st October 2023 @ 11:22 PM
    Join Date
    01 Jul 2010
    Location
    Faisalabad
    Age
    26
    Gender
    Male
    Posts
    1,294
    Threads
    132
    Credits
    346
    Thanked
    79

    Default

    yar time and date colum me jar kr sett kr do. bs

  4. #4
    Join Date
    21 Dec 2008
    Location
    Faisalabad
    Age
    41
    Gender
    Male
    Posts
    2,588
    Threads
    104
    Credits
    4,372
    Thanked
    173

    Default

    Step 3: Calculate Hours worked
    In Cell F2, type: =IF((((C2-B2)+(E2-D2))*24)>8,8,((C2-B2)+(E2-D2))*24)
    In cell G2, type =IF(((C2-B2)+(E2-D2))*24>8, ((C2-B2)+(E2-D2))*24-8,0)
    Step 4: Drag down and total
    In cell F10, sum regular hours, =SUM(F2:F8)
    In cell G10, sum overtime hours =SUM(G2:G8)
    Step 4: Calculate Pay:
    In cell F11, type: =SUM(F10*$J$1)
    In cell F12, type =SUM(G10*$J$2)
    Sum F11 and F12 for total pay. Type =SUM(F11+G11)


    Date
    Log in
    Lunch Starts
    Lunch Ends
    Log Out
    Regular Hours
    Overtime Hours
    Monday
    9:00 AM
    1:00 PM
    1:30 PM
    6:00 PM
    8.00
    0.50
    Tuesday
    9:20 AM
    11:57 AM
    12:15 PM
    6:00 PM
    8.00
    0.37
    Wednesday
    9:00 AM
    12:00 PM
    12:32 PM
    5:15 PM
    7.72
    0.00
    Thursday




    0.00
    0.00
    Friday




    0.00
    0.00
    Saturday




    0.00
    0.00
    Sunday




    0.00
    0.00











    Total Hours
    23.72
    0.87




    Pay
    $260.88
    $14.30



















    Total Pay
    $275.18

















    Quote zahid4942 said: View Post
    helo doston,

    may aik sheet ready kar raha hn jis may Over Time calculate ka formula lagana hay. par mujhe samajh nhy aa raha. koi dost hay jo ye formula laga sake. may file upload kar raha hn.

  5. #5
    zahid4942's Avatar
    zahid4942 is offline Senior Member+
    Last Online
    4th August 2022 @ 03:46 PM
    Join Date
    20 Mar 2010
    Location
    korangi
    Gender
    Male
    Posts
    469
    Threads
    120
    Credits
    1,478
    Thanked
    18

    Default

    Quote loyal_cupid said: View Post
    Step 3: Calculate Hours worked
    In Cell F2, type: =IF((((C2-B2)+(E2-D2))*24)>8,8,((C2-B2)+(E2-D2))*24)
    In cell G2, type =IF(((C2-B2)+(E2-D2))*24>8, ((C2-B2)+(E2-D2))*24-8,0)
    Step 4: Drag down and total
    In cell F10, sum regular hours, =SUM(F2:F8)
    In cell G10, sum overtime hours =SUM(G2:G8)
    Step 4: Calculate Pay:
    In cell F11, type: =SUM(F10*$J$1)
    In cell F12, type =SUM(G10*$J$2)
    Sum F11 and F12 for total pay. Type =SUM(F11+G11)


    Date
    Log in
    Lunch Starts
    Lunch Ends
    Log Out
    Regular Hours
    Overtime Hours
    Monday
    9:00 AM
    1:00 PM
    1:30 PM
    6:00 PM
    8.00
    0.50
    Tuesday
    9:20 AM
    11:57 AM
    12:15 PM
    6:00 PM
    8.00
    0.37
    Wednesday
    9:00 AM
    12:00 PM
    12:32 PM
    5:15 PM
    7.72
    0.00
    Thursday




    0.00
    0.00
    Friday




    0.00
    0.00
    Saturday




    0.00
    0.00
    Sunday




    0.00
    0.00











    Total Hours
    23.72
    0.87




    Pay
    $260.88
    $14.30



















    Total Pay
    $275.18



    Thanks for reply.

    Kya ap ye sheet bana kar upload karen ge mere lye. plzzzzzzzzz

Similar Threads

  1. How to remove Formula Link in Excel.
    By Rahmatullah Ktk in forum Ask an Expert
    Replies: 1
    Last Post: 4th April 2016, 12:28 PM
  2. Solved Need help ( Excel sheet)
    By azhar aali in forum Solved Problems (IT)
    Replies: 5
    Last Post: 2nd June 2014, 10:25 AM
  3. Want excel formula for this .... problem
    By Nadeem Ahmed Kh in forum Ask an Expert
    Replies: 5
    Last Post: 23rd July 2012, 02:25 PM
  4. Excel sheet formula problem...
    By Sarfraz Hussain in forum Ask an Expert
    Replies: 3
    Last Post: 19th June 2012, 09:59 AM
  5. Solved Excel Sheet Formula
    By Shireen Shari in forum Solved Problems (IT)
    Replies: 44
    Last Post: 1st June 2012, 09:36 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
  •