+ Reply to Thread
Results 1 to 7 of 7

Calculate Break deduction for timesheet summary

  1. #1
    Registered User
    Join Date
    05-11-2017
    Location
    Hamilton
    MS-Off Ver
    2016
    Posts
    12

    Calculate Break deduction for timesheet summary

    I have to do a timecard summary, but our production does not clock out for breaks, they just get a half an hour for a full shift (any thing over 6:00).

    So in column P I want it to be formatted to read 2:30 for 5 shifts, and 2:00 for 4 shifts, but only if they are 6 hours or more.
    Thank you in advance
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Calculate Break deduction for timesheet summary

    Try this in P3

    =TIME(0,30,0)*COUNT(IF((C$2:N$2="TIME OUT")*(C3:N3)-(C$2:N$2="TIME IN")*(C3:N3)>=TIME(6,0,0),C3:N3)) Ctrl Shift Enter

  3. #3
    Registered User
    Join Date
    05-11-2017
    Location
    Hamilton
    MS-Off Ver
    2016
    Posts
    12

    Re: Calculate Break deduction for timesheet summary

    Didn't work, only came up 0.00

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Calculate Break deduction for timesheet summary

    You have to enter the formula with Ctrl+Shift+Enter and not just Enter.

    You should get 0.1. Then format as h:mm to get 2:30.

  5. #5
    Registered User
    Join Date
    05-11-2017
    Location
    Hamilton
    MS-Off Ver
    2016
    Posts
    12

    Re: Calculate Break deduction for timesheet summary

    IT WORKED!! thank you

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Calculate Break deduction for timesheet summary

    You're welcome. If this solved your question, please mark this thread as SOLVED.

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    17,771

    Re: Calculate Break deduction for timesheet summary

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 04-03-2017, 11:21 AM
  2. Replies: 2
    Last Post: 02-20-2014, 06:20 AM
  3. [SOLVED] Can I calculate tax percentage deduction based on individual circumstance?
    By RAS 2112 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2013, 09:51 AM
  4. [SOLVED] "Calculate 2 different options based on standard 1060.00 per week deduction."
    By JanineBryant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-06-2013, 01:04 AM
  5. Timesheet Summary Page - Complicated
    By allan_j in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2009, 05:09 AM
  6. Timesheet to calculate No Hours?
    By Mehhico in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2008, 02:59 AM
  7. Timesheet without break times
    By village_idiot in forum Excel General
    Replies: 5
    Last Post: 05-03-2007, 11:01 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1