Hello Ozgrid members,
This is how the minute and second look like in A1: 35.02
I see that it's formatted as decimal number (decimal places 2 as negative). I want to change it to seconds only in next cell. Normally, desired result should look like this: 1277. I couldn't handle it any help would be great. Thank you!