Convert HH:MM to Seconds Using Excel 2000

[Honduras2811]

I have a cell that shows a calculated time in HH:MM format. The cell is formatted as Time. I would like to convert the contents of the field to seconds. I've tried the Convert function, but it gives me an error.

I've tried =((Hour(I4) * 3600) + (Minute(I4) * 60)) but the result is always 00:00.

Can someone tell me what I am doing wrong?

[p45cal]

Can someone tell me what I am doing wrong?

The format of the time-cell hides its value which is in days; multiply by 86400, the number of seconds in a day and remember that the format of the cell should not be any date/time format. Use for eaxample: General

Another way is to change the format of the cell containing the time to a custom format:
[ss]
but it will retain the excel date/time values but show seconds.