COnvert to seconds

And what should be the result (and why)?

Originally Posted by aakhan2011

I need some formula to convert a data to seconds.
21:2
19:19
9:8

If A1 contains Excel time formatted as [h]:m or [m]:s, then =A1*86400

If A1 contains Excel time formatted as [h]:m, but 21:2 should be interpreted as 21 min 2 sec, then =A1*1440.

Note: That can result in fractional seconds. If you want integer seconds, round the appropriate formula, e.g. =ROUND(A1*86400,0).