Converting Time
 

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

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

Converting Time
 

try:

=A1*60*60*24

And format the cell as General.

Brento wrote:

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

--

Dave Peterson