two decimals into seconds

[baitrock]

Hey i've been stuck on this for a while.. dont know if its possible.

I always need to turn min.sec into seconds eg. 2.14 = 194 seconds

i have been using 3 cells

Min | Sec | Seconds
2 14 =min*60+Sec

i was wondering if it possible to get a number with 2 decimal places into seconds.

any ideas?

Thankx
-BaitRock

[mikerickson]

If A1 holds a time in m.ss format

=60*INT(A1)+100*MOD(A1,1)

will return the number of seconds

1.2 >> 80 seconds
1.02 >> 62 seconds
2.14 >> 134 seconds
3.14 >> 194 seconds

[baitrock]

Thankx Mate.. that helps heaps.. I been tryin to figure that out for aaaages.

[mikerickson]

You're welcome.

I'm going to move this thread to the Excel Worksheet Functions sub-forum.
Excel Programming is focused on VBA rather than spreadsheet formulas.

I'm glad I could help.