Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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.
Thanks! |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |