Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2002
    Location
    Leamington Spa, Warwickshire, England
    Posts
    136
    Thanks
    0
    Thanked 0 Times in 0 Posts

    time Formatting (xp 2002)

    I want to create a sprreadsheet which lists calls made to a help desk. The call length will then be multiplied by the total number of calls . what is the best way of formatting the data so I can have call duration dispalyed in hours and minutes? I have triedd using the time formats but if the total number of calls is over 24 hours it converts itt o actual time (i..e 03:00 ---3am, not the 27 hours it should be)

    Thanks

    Michelle <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: time Formatting (xp 2002)

    Use [h] or [hh] for a count of hours that can exceed 24. There is a built-in time format for this in the Time category of the Number tab of Format | Cells...

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: time Formatting (xp 2002)

    Set a custom format like this:

    [h]:mm:ss
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •