Help me Convert!!!
 

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!

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