Meg Wrote:
Is there a way to convert a time of 1:04.69 to 64.69 in excel?

Thanks in advance!
Meg

if you want to convert a time to seconds multiply by 86400 (the number
of seconds in a day), e.g.

=A1*86400

where A1 contains your time

format result cell as number


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555147