| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help me Convert!!!
Hi,
Am Mon, 3 Nov 2014 23:35:21 +0000 schrieb A+ Positive Solutions: I have data in a column in the format 0:04 or 0:11. In the next column I want to take the numbers to the right of the colon and multiply by 9.75. I would also like a way to drop off the 0: from each column. format your column in custom format: [0,0416667]h:mm;mm To multiply the value right of the colon: =MINUTE(A1)*9.75 and format the cell General Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
| Convert Columns of Sensitive Information, and then convert back... | Excel Programming | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) | |||
Threaded Mode
