Convert Time to Number (integer)

Automate Excel

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

2 Responses

  1. Ajith Chanaka Says:

    The method is very very useful.
    Thanx

  2. Ged Says:

    Sweet!

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.