I would like to know how to convert minutes and seconds to seconds in Excel example 1.34=how many seconds?

To do this you actually have to get Excel to seperate the digit to the left of the decimal from the right of the decimal then multiply the digit on the left by 60 and add it to the number on the right side. Here's the exact formula.

A1 will be the number you want to input (in this case it will be 1.34)

B1 - enter the formula: =ROUNDDOWN(A1,0)

C1 - enter the formula: =A1-B1

D1 - enter the formula: =(B1*60)+(C1*100)

You can hide columns B1 and C1 (select the 2 columns, click Format, select columns, select Hide).

I take it that you used a stopwatch or something and the reading is 1.34 minutes. With a pocket calculator you would multiply 1.34 times 60 to convert to seconds, right? The answer would be 80.4 seconds.

In Excel you'll need to use a function to do that (don't worry, it's easy!). Here's how it works:

Type 1.34 in cell A1. Now type in B1 this: =A1*60

That's it! As soon as you type your time in A1, you'll get an answer in B1 (converted into seconds, as requested).

Try avoid using decimals for time calculations.

Its not intuitive. For example

0.34 formatted will show 8:09

But if you put 8:09 in a different cell and try to compare them using equal = sign, the answer you get will be false as 8:09 is equal to 0.339583333

To work out the number of secs, type in as time eg

06:20 (A1)

00:01 (A2)

=A1/A2 (A3) Answers 380 secs,

how long is 00 07 00 in seconds

If your time of minutes and seconds is in cell B2, then in C2, paste this

=MINUTE( B2)*60+SECOND( B2)

That is all, you may need to reformat cell C2 back into Integer

Yes, I am the VBAXLMan here

Go to "Format" "cells" "custom" and set the cell for ss (seconds).

Hope that helps.