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

Posted in

Leave a Comment