Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2003
    Thanked 0 Times in 0 Posts

    Times and Numbers (Excel 97)

    I have a time in the format 23:43:00 for 23 hours, 43 mins and zero secs. I want to know how to calculate this into minutes in the next cell (e.g. 1423 minutes) in Excel 97.

    Any ideas?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Times and Numbers (Excel 97)

    A time is stored as a fraction of a day, so 12:00:00 is 0.5, and 18:00:00 is 0.75. To convert any time to minutes, multiply the time by the number of minutes in a day (24 * 60 = 1440), and clear the formatting of the result (by default, Excel will format the cell with the formula as time too).

    So if the time is in cell A1, use the formula =A1*1440, or if you like to see how it is derived, =A1*24*60 and select Edit | Clear | Formats.

Posting Permissions

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