Results 1 to 13 of 13

Time calculator returning negative result until punch-out is recorded?

Threaded View

  1. 08-16-2018, 10:35 AM #1
    taylorsm
    taylorsm is offline
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Time calculator returning negative result until punch-out is recorded?

    I have a timesheet calculator and when you enter in 8:00 AM then the formula that calculates the hours worked enters -8.00. Once you put in a clock out time then it corrects itself, but why is it doing -8?

    e.g.

    In / Out / Hours
    8:00 / / -8.00
    8:00 / 12:00 / 4.00

    Workbook is attached that shows the -8.00. I know I could make the formula just be blank until the second entry but why does it return a negative prematurely?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help with Punch in and Punch out clock system please.
    By Grassman in forum Excel Programming / VBA / Macros
    Replies: 74
    Last Post: 02-27-2020, 02:16 AM
  2. Elapsed time negative result
    By OllieKP87 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-02-2014, 02:30 PM
  3. Clock in multiple punch in/punch out times Formula
    By Schnizzle74 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2014, 06:15 PM
  4. [SOLVED] Transpose the Punch Time
    By skandkamat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2013, 01:12 AM
  5. need one formula for returning positive or negative time w/out #######
    By completelyhis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-11-2013, 09:12 AM
  6. How to get a negative time result without using additional cell data
    By sherlock99 in forum Excel General
    Replies: 0
    Last Post: 10-12-2012, 07:57 AM
  7. Prevent Formula Returning Negative Result
    By Manic in forum Excel General
    Replies: 2
    Last Post: 11-09-2011, 11:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1