## 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

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.

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.