Conditional formula based on if a cell is hh:mm:ss or mm:ss

Hi good people

I am needing some assistance writing a formula that can calculate a cell that may appear in either hh:mm:ss or mm:ss format to the correct number of seconds.

I am aware that using the formula =A1*1440 will give the correct number of seconds if cell A1 contains an entry that in the format mm:ss
but if cell A1 contains a value in the format hh:mm:ss then the incorrect value is displayed and the correct formula =A1*86400 should be used.

For example (Please note cell A1 is formatted as Text)

Cell A1 = 40:10 =A1*1440 = 21410 seconds (Correct)
Cell A1 = 00:27 =A1*1440 = 27 seconds (Correct)
Cell A1 = 1:20:35 =A1*1440 = 80.583 seconds (Incorrect)
Cell A1 = 1:20:35 =A1*86400 = 4835 seconds (Correct)

Is there a formula that can be written which can take into account the difference time formats?

Any help would be appreciated.

Thanks
Steve

Hi Quang.
Thanks for your reply.

As mentioned above, cell A1 and all other cells that contain time are formatted as text.

So the underlining value is exactly as whats shown.

Any more ideas?

Steve

Thats works perfectly.
Thanks for your help..