Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Converting Time To Fractions

### #1 Michael Clarke Posted 03 March 2012 - 05:19 AM

Michael Clarke

New Member

• Member
• 1 posts
Hello,

I am doing a study and i need to convert swimming times into fractions for it to then be entered into SPSS. For example i need to convert 9 minutes 32 seconds. 54 tenths and hundreths. so i need to convert 09:32.54 into a fraction. I have looked through excel to convert cells, format them but still cannot find what im looking for! Can anybody please point me in the right direction.

Cheers Mike
• 0

### #2 Ax238 Posted 03 March 2012 - 04:16 PM

Ax238

Tech Staff

• Technician
• 1,323 posts
Hi Mike and welcome to geeks to go!

There is one vital piece of information missing: the denominator of the fraction. For our purposes here, I'll just guess the result will be fractions of hours. Here's a formula that should work, assuming you just have the times entered in Excel as you listed in your post (we'll assume the time value is in A1):
`=MINUTE(A1)/60+SECOND(A1)/3600`

So you'd have another column with this formula and just fill it down for your data. With this formula, I get the following for a time of 09:32.54 - 0.159166667

Please let me know if this is what you are looking for or if you need more assistance.

Regards,

Ax
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users