hour minutes to minutes

G

Guest

hi community

i formatted cells in this time format, [h]:mm:blush:o , and my result is 01:33
(one hour and 33 minutes) and another is 00:35 (35 minutes)

how can i convert my 2 cells to read in mm (minutes) only ?

thanks for the help :)

thanks community :)
 
G

Guest

hi mike

it works !! :)

thanks

thanks community as well :)
--
oldLearner57


Mike H said:
Try,

Custom format of [m]


Mike

oldLearner57 said:
hi community

i formatted cells in this time format, [h]:mm:blush:o , and my result is 01:33
(one hour and 33 minutes) and another is 00:35 (35 minutes)

how can i convert my 2 cells to read in mm (minutes) only ?

thanks for the help :)

thanks community :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top