hour minutes to minutes

O

oldLearner57

hi community

i formatted cells in this time format, [h]:mm:eek: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 :)
 
O

oldLearner57

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:eek: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 :)
Click to expand...
Click to expand...
 
Top