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