Converting Time

[Brento]

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

[Bob Phillips]

=A1*24*60*60

and format as General

--
HTH

Bob Phillips

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

"Brento" <Brento.2c8tl6_1155077121.2902@excelforum-nospam.com> wrote in
message news:Brento.2c8tl6_1155077121.2902@excelforum-nospam.com...
>
> 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]

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