another excel question

Discussion in 'Windows Desktop Systems' started by cam, Jul 20, 2003.

  1. cam

    cam Guest

    is it possible to convert a raw amount of minutes into h:m.. example


    you have a result of 116 minutes from another formula, but you want to convert it to 1h56m on the page.. outside of manually typing it (yech!) what are my options?

    thanks!
     
  2. Geffy

    Geffy Moderator Folding Team

    Messages:
    7,805
    Location:
    United Kingdom
    try Format Cells or something like that
     
  3. Khayman

    Khayman I'm sorry Hal... Political User Folding Team

    Messages:
    5,518
    Location:
    England
    this should work

    =INT(A1/60)&" hours "&MOD(A1,60)& " minutes"

    Change A1 to whatever cell the minutes are in
     
  4. cam

    cam Guest

    you guys never cease to amaze.

    thanks