Format as [m] but it won't convert it to 90 minutes, 60+20 is 80

Or you can use

=TEXT(A1,"[m]")



--


Regards,


Peo Sjoblom


"Gostwin" wrote in message
...
Example I have added several activities and I end up with 1:20. or one
hour
20 minutes as text(hh:mm:ss). How do I automatically convert this to 90
minutes?

Thanks