Results 1 to 4 of 4

Thread: Excel

  1. #1
    Yorkeyite
    Guest

    Angry Excel

    I wish to format time as a quantity on a spreadsheet not as a chronological period. Not even sure if this is the correct way to express this.

    My problem is that I cannot show any shortfalls in time theoretically needed and time taken on jobs

    ie 5 hours assessed, 7 hours taken therefore -2hour deficit

  2. #2
    Security Specialist greEd's Avatar
    Join Date
    May 2001
    Location
    Maryland
    Posts
    807
    ? are you talking about macros ?
    "I'm doing a (free) operating system (just a hobby, won't be big and professional...) for AT clones... It's not portable and it probably [won't ever] support anything other than AT hard disks, as thats all I have :-(." --Posted on Usenet August 1991 by Linus Trovalds
    http://www.computerglitch.net
    curiosity builds security | dd if=/dev/zero of=/dev/hda bs=512 count=100
    EOF

  3. #3
    Yorkeyite
    Guest

    Excel

    No, formats.

    Currently using [h]:mm and while using the sum function allows me to exceed 24hours as a total it still will not allow me to produce a negative result.

    I need a format that allows me to do this

  4. #4
    Yorkeyite
    Guest

    Talking Excel

    Received information from elsewhere

    For those who are interested use the 1904date system (Tools/options)

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
  •