With your time (or 0:33:18) in A2:

=(HOUR(A2)+(MINUTE(A2)/60)+(SECOND(A2)/(60*60)))*-1

HTH,
Paul


--

"Dave Tee" wrote in message
...
Hello All,

I require help with the below formula.

=(0+(33/60)+(18/(60*60)))*-1

Certain numbers in the formula change.
The numbers that change are from left to right '0' '33' & '18'.

In this instance the '0' was a negative value (hence the *-1 on the end of
the formula).

I have many rows in which these numbers vary.

How can I target the formula at one cell (where the data source is, eg.
-0:33:18) and place the result (in this case -0.555) in another?

Sorry if I am not explaining very well. I hope you can understand it
though.

Thank you for your Help. David.