What is the formula for taking two times, and finding the minutes between them. E.g. 12:35 PM-12:28 PM=7. I know i can use (A1-A2)*1440, but is there an easier way? Thanks.
What is the formula for taking two times, and finding the minutes between them. E.g. 12:35 PM-12:28 PM=7. I know i can use (A1-A2)*1440, but is there an easier way? Thanks.
I'd say that's a pretty compact and easy way of doing it ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
You could also use just
=A1-A2
and custom format result cell as [m]
but be aware, if you do that, that the result will look the same.....but the underlying cell value is different (it's still a time value not an integer representing the number of minutes)
Audere est facere
Maybe this...
=A1-A2
Format as [m]
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That works. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks