Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating hours (2003)

    Ok...I am brain dead from all the holidays. I need to create a simple spreadsheet with a list of task and the number of minutes it took to complete the task. Once all totaled for the day, I divided by 60 (for mintues) but I get an funny number. IS there a formula to take total minutes and covert to actual hours and minutes?

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

    Re: Calculating hours (2003)

    Are you entering the durations as a number (e.g. 23) or as a time value (e.g. 0:23) ?

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating hours (2003)

    Just as a number...28 minutes is entered as 28.

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

    Re: Calculating hours (2003)

    in that case, dividing the sum by 60 should work. Try the following:
    - Select the cell with the formula.
    - Select Format | Cells...
    - In the Number tab, select General format.
    - Click OK.

    You can also select Number format, with 0, 1 or 2 decimal places.

Posting Permissions

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