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


Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
  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

    Hi John G..

    Thank you very much for the formula…….

  11. Khalid
    April 24th, 2011 at 08:52

    Greeeeeeat and very useful..thanks a lot.

  12. Clamps
    May 6th, 2011 at 03:46

    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

    This is totally great!!
    Thank you so much!

  14. Shirley
    October 19th, 2011 at 19:42

    Very helpful in completing my project.