Vba: converting hours in seconds

[Nelson78]

Hello everybody.

I've a value in a cell in hour format:

00:05:37

I need to transform it in seconds:

337

How can I manage the matter?

Thank's.

 

[John_w]

    Dim seconds As Long
    seconds = DateDiff("s", 0, Range("A1").Value)

 

[Nelson78]

    Dim seconds As Long
    seconds = DateDiff("s", 0, Range("A1").Value)

Fine, thank's.