Converting hh:mm:ss to seconds only

[kippers]

Hi,

Just wondered if anyone could advise me on the easiest way to convert a
value in a cell formated as hh:mm:ss into seconds only i.e. 00:01:30 would
equal 90.

Cheers,

 

[SteveW]

Cell contains time as fraction of a day

So if A1 = time
use =A1*24*60*60

Steve

 

[Gary''s Student]

format with:
[ss]