Convert Time to Number (integer)
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!
Get answers right away at our AE Excel Support Forums!



The method is very very useful.
Thanx
Sweet!
Genius! Muchos Gracias!
excellent
Thank you very much
excellent. you are a genius. Thank you a ton
very much useful
thanks
Tried everything till i landed in this website. Tons of thanks
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
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!
Hi John G..
Thank you very much for the formula…….
Greeeeeeat and very useful..thanks a lot.
Thanks!
I was searching in converting number to time, I never thought the answer was the other way around.
Thank you again.
This is totally great!!
Thank you so much!
Very helpful in completing my project.