How do I convert a cell with 1:23 to 83 minutes in a formula?
How do I convert a cell with 1:23 to 83 minutes in a formula?
Try multiplying by 1440 (the number of minutes in a day) so if A2 has 1:23 use this formula in B2
=A2*1440
format B2 as number or general
Audere est facere
Thanks, that works perfectly. Take care, Rob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks