convert minutes to seconds

D

davidkandy

I have a series of race times that are entered in minutes format (4:01) and I
want to convert to seconds in decimal format.
 
D

David Biddulph

I think you'll have to multiply by at least another 60, as Mike's 24
converts from days (Excel's unit of time) to hours.
4:01 will be interpreted as hours and minutes, not minutes and seconds, so
if you intended 4:01 to be minutes and seconds, multiplying by 24*60 would
give you the number of seconds. If you have a time which is genuinely 4:01
in minutes and seconds (entered as 0:4:01 or as 4:01.0), then you'll need to
multiply by 24*60*60 to get from Excel time to decimal seconds.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert decimal figure to minutes and seconds 3
convert minutes and seconds (in a date format) to numbers 6
Does anyone know how to create a pace calculator (min/mile) in Exc 10
Formating seconds into mm:ss 4
How to convert number in to time lenght, minutes and seconds? 3
Convert hours to minutes 2
i want to convert decimals into time format 3
How do you convert decimal degrees to degrees minutes seconds 2

Top