| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Integer convert to minutes.
I want to take the solution to a simple arithmetic formula, say 90/18, and
have it output as a value in minutes. I have been unable to figure this one out. In my spreadsheet, I want the answer for 90/18 to be :05. However, all the time functions that I have utilized (timevalue, minute, text (x, ":mm") ) are all giving me a value of :01. Does anyone know how to make that integer display as that number of minutes? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract decimal and convert to integer | Excel Discussion (Misc queries) | |||
| Convert integer to time query | Excel Discussion (Misc queries) | |||
| How do I convert char into integer in Excel VBA? | Excel Discussion (Misc queries) | |||
| Convert Text to Integer | Excel Discussion (Misc queries) | |||
| Convert time into integer | Excel Worksheet Functions | |||
Threaded Mode
