Displaying hh:mm:ss in seconds

[Thorbjorn Sundboe]

How can I convert numbers stored as hh:mm:ss to display as seconds?

Cheers, Thorbjorn

 

[Frank Kabel]

Hi
use
=A1*24*60*60
and format as 'Number'

 

[JE McGimpsey]

Since XL stores times as fractional days:

=A1*24*60*60

or, equivalently:

=A1*86400

 

[Earl Kiosterud]

Thorbjorn,

Format - Cells - Number tab - Custom:

[ss]