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
The method is very very useful.
Genius! Muchos Gracias!
Thank you very much
excellent. you are a genius. Thank you a ton
very much useful
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.
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.
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.
Copyright © 2004-2013 Automate Excel | Powered by WordPress | Theme by NeoEase