Thread: Converting Time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Converting Time

=A1*24*60*60

and format as General

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brento" wrote in
message ...

Hi,

I am trying to change 00:10:44 minutes into 644 seconds

But no matter what I try the formula is wrong and/or the format comes
back wrong also.

please help.

thanks
Brento


--
Brento
------------------------------------------------------------------------
Brento's Profile:

http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=569679