[Gostwin]

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

[Peo Sjoblom]

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

[FSt1]

hi
multiply by 1440 and format as general.
why 1440?
time is kept by excel as a decimal value of 1 day.
1:20:00 (or 90 minutes) =.0625 day
24 hours times 60 minutes = 1440 minutes in a day.
..0625 times 1440 = 90 minutes.

regards
FSt1


"Gostwin" wrote:

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