+ Reply to Thread
Results 1 to 4 of 4

Time card help!!!!!!!!!!!!!

Hybrid View

chops15 Time card help!!!!!!!!!!!!! 07-20-2015, 11:33 PM
jhren Re: Time card... 07-21-2015, 01:46 AM
jhren Re: Time card... 07-21-2015, 01:49 AM
chops15 Re: Time card... 07-21-2015, 07:16 PM
  1. #1
    Registered User
    Join Date
    07-20-2015
    Location
    seattle
    MS-Off Ver
    Microsoft Office 2011 for Mac
    Posts
    4

    Time card help!!!!!!!!!!!!!

    My company is using handouts for our time cards and we take a picture and send it out to the office at the end of the week. I'm tired of printing them out or running out of sheets and would like to do this on the go with my iPhone and send the pdf to my boss. I have the formula figured out for time start and time stop total hours. Where I ran into the problem is I want to be able to enter in .5 in the lunch cell and have this automatically be subtracted when I do so. If I don't add the .5 than my hours stay they same.

    Example: My shift starts at 7:00 am. Ends at 3:30. This includes lunch. My company wants us to but in .5 for the lunch section and this gives us a value of 8 in the TOTAL CELL for the day. I sometimes take lunch and sometimes just work through the day without one. So I would like to be able to just enter in the time I start, stop, and if I take a lunch I add .5 and have that calculated in. If I leave it blank than no subtraction is needed. I've been trying for hours and can't come up with a good solution. The time format is giving me lots of trouble. Can anyone help me solve this?

    TIME START CELL: X11
    TIME STOP CELL: Y11
    TOTAL CELL: Z11

    LUNCH CELL: U11

    To get the total I have the formula as =(y11-x11)*24, which gives me the format that my company likes to use.


    Also, when I copied this formula all the way down to the bottom of the totals column it works perfectly but is their away to get rid of the "0.00" value when i have no values for TIME START and TIME STOP? I still want it to function but just want more white space to make this easier to read.

  2. #2
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Time card help!!!!!!!!!!!!!

    If you just want to enter 3:30, rather than 3:30 PM, for stop time, try the following:
    =(IF(Y11<X11,Y11+12/24,Y11)-X11)*24-U11
    Explanation: Excel registers a 3:30 entry as 3:30 AM, so you trick it into calculating afternoon hours as PM by adding 12 hours.

  3. #3
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Time card help!!!!!!!!!!!!!

    To get rid of the "0.00" values...
    =IF(OR(X11="",Y11=""),"",(IF(Y11<X11,Y11+12/24,Y11)-X11)*24-U11)

  4. #4
    Registered User
    Join Date
    07-20-2015
    Location
    seattle
    MS-Off Ver
    Microsoft Office 2011 for Mac
    Posts
    4

    Re: Time card help!!!!!!!!!!!!!

    NICE!!!! Everything works very well now, just how I like it. Thank you

+ 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. Budgeting out percentages of time from a time card calculation sheet
    By mhadaway in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2015, 05:05 PM
  2. excel time card & time sheet
    By imranccri in forum Excel General
    Replies: 1
    Last Post: 01-14-2015, 06:04 AM
  3. Time Card
    By bobanderson123 in forum Excel General
    Replies: 0
    Last Post: 07-09-2012, 05:09 PM
  4. [SOLVED] Verifiying In - Out time on time card is <10hrs
    By bobanderson123 in forum Excel General
    Replies: 10
    Last Post: 07-09-2012, 03:40 PM
  5. [SOLVED] Converting time to hours in a time card
    By frankday in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2012, 06:04 PM
  6. Replies: 7
    Last Post: 05-18-2009, 02:00 PM
  7. Time Card.
    By kathemius in forum Excel General
    Replies: 2
    Last Post: 10-04-2007, 03:21 PM

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