Is it 1.20 or 1:20?
If the former
=DOLLARDE(A1,60)*60
note: DOLLARDE function requires Analysis ToolPak to be enabled
if the latter then how is the cell formatted? if h:mm then
=A1*1440 format as general
If m:ss
=A1*86400 format as general
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=568764