Forgot to say that you need to set the number format in cell B2 to Number
with no decimal places.
--
Regards,

OssieMac


"OssieMac" wrote:


Assume that 0:21 is in cell A2

Put the following formula in cell B2

=A2*24*60

The explanation is that time is a fraction of one day. Therefore multiply
the fraction by 24 to change it to hours then multiply by 60 to change it to
minutes.

--
Regards,

OssieMac