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
|