Convert text entered as minutes/seconds to minutes

K

Kathie

I have several entries (formatted as text) for example, :31, 1:04, 4:53,
23:34. These numbers indicate minutes and seconds (31 seconds, 1 hour 4
seconds, etc).
What formula can I use to convert these entries into seconds?
 
F

Fred Smith

If you really meant 1:04 is "1 hour 4 seconds", you've got problems, because
this is indistinguishable from the same entry meaning 1 minute, 4 seconds.
Assuming you meant the latter, use the following to convert to seconds:
=timevalue(a1)*60*24

Format as a number. The Timevalue function isn't really necessary, but I
like to use it because it makes the formula clearer to me.

Regards,
Fred
 

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

Top