If I have 1:50 (cell format [H]:MM) in cell A1 could anyone help with a formula that would convert cell B1 into the number of minutes in the 1 hr 50 mins please
Thanks
If I have 1:50 (cell format [H]:MM) in cell A1 could anyone help with a formula that would convert cell B1 into the number of minutes in the 1 hr 50 mins please
Thanks
Format cell as [m]:ss
nje,
This should do it, format as General:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
depends on the desired output format, either
=A1 format as [m] (returns 110 minutes as a time value, i.e. 0.08 days).
or
=A1*1440 format as general / number (returns 110 as an integer not as a time value).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks