| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hour minutes to minutes
hi community
i formatted cells in this time format, [h]:mm:oo , 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 :) -- oldLearner57 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hour minutes to minutes
Try,
Custom format of [m] Mike "oldLearner57" wrote: hi community i formatted cells in this time format, [h]:mm:oo , 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 :) -- oldLearner57 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
hour minutes to minutes
hi mike
it works !! :) thanks thanks community as well :) -- oldLearner57 "Mike H" wrote: Try, Custom format of [m] Mike "oldLearner57" wrote: hi community i formatted cells in this time format, [h]:mm:oo , 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 :) -- oldLearner57 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
| Change 60 minutes to 1 hour | New Users to Excel | |||
| How can I add hours and minutes then multiply by cost per hour? | Excel Worksheet Functions | |||
| converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
| Calculate hour and minutes worked each day | New Users to Excel | |||
Linear Mode
