Convert Time to Number (integer)

August 15th, 2004 | Categories: Formulas | Tags:
-->

If you have a time in the format of 1:30:00 but want it to display as the integer 90, here’s the formula.

1. Multiply the time you want to convert to a number by 1440
2. Format the cell as number

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. Ajith Chanaka
    August 29th, 2008 at 11:43
    Reply | Quote | #1

    The method is very very useful.
    Thanx

  2. Ged
    September 9th, 2008 at 07:05
    Reply | Quote | #2

    Sweet!

  3. El Bill
    July 16th, 2009 at 20:05
    Reply | Quote | #3

    Genius! Muchos Gracias!

  4. santosh
    August 17th, 2009 at 06:44
    Reply | Quote | #4

    excellent
    Thank you very much

  5. santosh
    August 17th, 2009 at 06:46
    Reply | Quote | #5

    excellent. you are a genius. Thank you a ton

  6. M Ashraf
    May 9th, 2010 at 07:24
    Reply | Quote | #6

    very much useful
    thanks

  7. Prabhakar madhiraju
    July 26th, 2010 at 09:10
    Reply | Quote | #7

    Tried everything till i landed in this website. Tons of thanks

  8. John G
    August 5th, 2010 at 16:34
    Reply | Quote | #8

    Very useful. I might be pointing out something obvious, after you convert time format to the number, you’ll want to divide by 60 to achive the integer “time” number. I need that because I then multipled against a dollar amount. I had not seen anyone else comment, so I though I’d thow my .02.
    Thanks

  9. Tracey H
    January 6th, 2011 at 16:19
    Reply | Quote | #9

    OMG thank you so much! This is exactly what I was looking for, and it enabled me to complete my employee annual reviews with accurate OT reduction info. You are my hero!

  10. Pooja Tripathi
    January 11th, 2011 at 05:02
    Reply | Quote | #10

    Hi John G..

    Thank you very much for the formula…….

  11. Khalid
    April 24th, 2011 at 08:52
    Reply | Quote | #11

    Greeeeeeat and very useful..thanks a lot.

  12. Clamps
    May 6th, 2011 at 03:46
    Reply | Quote | #12

    Thanks!

    I was searching in converting number to time, I never thought the answer was the other way around. :)

    Thank you again.

  13. Sampat
    October 16th, 2011 at 02:20
    Reply | Quote | #13

    This is totally great!!
    Thank you so much!

  14. Shirley
    October 19th, 2011 at 19:42
    Reply | Quote | #14

    Very helpful in completing my project.