Results 1 to 13 of 13

entering a minus time value into a cell

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    entering a minus time value into a cell

    Confusing title! I've nearly finished (with the help from forumites) my daughters timesheet.
    The problem is cell N2. They use flexitime and some weeks they go into negative hours or minutes. This isn't a problem when doing calculations but when they first use this timesheet, they will need to transfer theiir records over from paper. The cell for the flexitime is N2 and this could be for example -3:05. but when I enter the minus sign before the time -3:05 it thinks it is a formula and won't accept it. Any ideas.
    Thanks
    Attached Files Attached Files
    Last edited by nje; 08-05-2010 at 11:03 AM.

Thread Information

Users Browsing this Thread

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

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