| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting Days Hours & minutes into just minutes in excel
Six Sigma Blackbelt Wrote: converting Days Hours & minutes into just minutes in excel, this is my data set - 0:16:30 in Day hours and minutes, I need to change this to just minutes wich would be 990 minutes, how can i do this please. If you're just concerned with what is displayed..... If you input 0:16:30 in excel then this will be interpreted as 16 minutes 30 seconds.In this case to display as 990 custom format as [s] If you do indeed have a cell formatted as d:hh:mm which shows 0:16:30 then just reformat as [m] and it should show 990 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=537357 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert an elapsed time in minutes to Days hours and minute | Excel Discussion (Misc queries) | |||
| Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
| Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Adding hours and minutes | Excel Discussion (Misc queries) | |||
Threaded Mode
