+ Reply to Thread
Results 1 to 3 of 3

error calculating negativ difference time values

  1. #1
    Xavier
    Guest

    error calculating negativ difference time values

    hello.

    i have a xls with 3 rows with the cell fprmat as time hh:mm

    example of the values
    col 1 - nr of hh:mm worked on a day
    col 2 - nr of standard hh:mm to work on a day
    col 3 - calcualated - col1 -col2 - it shows if someone has worked more or
    less then the default time

    example

    08:00 08:00 00:00 ok
    09:30 08:00 01:30 ok
    07:00 08:00 Problem !!!! - i want here to have -01:00

    is this possible?
    thanks







  2. #2
    Chip Pearson
    Guest

    Re: error calculating negativ difference time values

    Excel can calculate, but not display, negative times. You can
    enable it to display negative times, by switching to the 1904
    Date System. Go to the Tools menu, choose Options, then the
    Calculation tab. There, check the 1904 Date System option. Note,
    however, that this will cause existing dates in the workbook to
    be 4 years off.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Xavier" <[email protected]> wrote in message
    news:[email protected]...
    > hello.
    >
    > i have a xls with 3 rows with the cell fprmat as time hh:mm
    >
    > example of the values
    > col 1 - nr of hh:mm worked on a day
    > col 2 - nr of standard hh:mm to work on a day
    > col 3 - calcualated - col1 -col2 - it shows if someone has
    > worked more or
    > less then the default time
    >
    > example
    >
    > 08:00 08:00 00:00 ok
    > 09:30 08:00 01:30 ok
    > 07:00 08:00 Problem !!!! - i want here to have -01:00
    >
    > is this possible?
    > thanks
    >
    >
    >
    >
    >
    >




  3. #3
    Xavier
    Guest

    Re: error calculating negativ difference time values

    thanks, it works
    regards

    "Chip Pearson" wrote:

    > Excel can calculate, but not display, negative times. You can
    > enable it to display negative times, by switching to the 1904
    > Date System. Go to the Tools menu, choose Options, then the
    > Calculation tab. There, check the 1904 Date System option. Note,
    > however, that this will cause existing dates in the workbook to
    > be 4 years off.
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    >
    > "Xavier" <[email protected]> wrote in message
    > news:[email protected]...
    > > hello.
    > >
    > > i have a xls with 3 rows with the cell fprmat as time hh:mm
    > >
    > > example of the values
    > > col 1 - nr of hh:mm worked on a day
    > > col 2 - nr of standard hh:mm to work on a day
    > > col 3 - calcualated - col1 -col2 - it shows if someone has
    > > worked more or
    > > less then the default time
    > >
    > > example
    > >
    > > 08:00 08:00 00:00 ok
    > > 09:30 08:00 01:30 ok
    > > 07:00 08:00 Problem !!!! - i want here to have -01:00
    > >
    > > is this possible?
    > > thanks
    > >
    > >
    > >
    > >
    > >
    > >

    >
    >
    >


+ Reply to Thread

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