The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel

    Discussion in 'Windows OS and Software' started by Elias, May 7, 2005.

  1. Elias

    Elias Notebook Consultant

    Reputations:
    6
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    30
    I don't do a lot of work with spreadsheets and the like, but am now in a situation which would benefit me most to use one.

    I am making a log of my running. I want to input the date, the distance ran, the time ran, and the approximate amount of calories burned (according to the treadmill).

    I've come across a problem with the times I input. I want to put them in the format minutes:seconds, reguardless of whether or not it was an hour or more.

    The other thing I want is a total distance, time, and calories. I want the total time to be calculated in the form hours:minutes:seconds.

    Does anyone know of a way to achieve this? I apologize for being an Excel newbie. This is probably a simple problem, but I have not found a solution.

    Thanks!
     
    Elias, May 7, 2005
    #1
  2. qwester

    qwester Notebook Virtuoso

    Reputations:
    366
    Messages:
    2,755
    Likes Received:
    0
    Trophy Points:
    55
    right click on a cell or a group of selected cells and go to "format cells" here you can specify anything about your data type.
    when the data type is set correctly then normal math claculations will work on them such as 40sec + 50sec = 1:30sec

    ----------------------------------------------------------------------------
    N6010: P4M 3.2G, 512MB Dual 333MHz, 60GB 7200RPM, ATI 9700M, 17" WXGA+
    ----------------------------------------------------------------------------
     
    qwester, May 7, 2005
    #2
  3. Elias

    Elias Notebook Consultant

    Reputations:
    6
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    30
    Awesome. Thanks man. It's working great!
     
    Elias, May 7, 2005
    #3