Results 1 to 2 of 2

converting time units

Threaded View

  1. #1
    Registered User
    Join Date
    03-31-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question converting time units

    I am attempting to convert time units from one format to another. Here is an example of what I am trying to do (but without success).

    Currently I have time in the following format (hh:mm:ss)
    I need to have this format converted to just minutes (mm)

    I have tried =convert(A1 ("hr":"mn":"sec","mn")) and I receive an error saying the formula is invalid.

    I don't know of any other formulas to try.

    In other words I need 9:46:55 (9 hours 46 minutes 55 seconds) to say 586.92 (586.92 minutes)


    Any advise is greatly appreciated. I've been pulling my hair out on this one for a while now.
    Last edited by tinsles2; 04-05-2011 at 07:04 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1