Formating Cells for Time

S

Steven_Phillips77

I have formatted each cell as a time cell. I would like to take the
time, 4 minutes 30 seconds and 20 one hundredth of a second, use a
formula in column B and multiply column A by 0.225. Have the results
diplayed as, 1 minute, 00 seconds and 75 one hundredth of a second.


Column A Column B
4:30.20 1:00.75

Could someone please Help?
 
G

Guest

I can't tell if you want the results to be text or you wasnt column B to show
that particular number
column B is not thew reult of multiplying 4:30.20 *.225
the results for that would be 1:00.80 or 1:00.795
if you are getting

make sure your time format is custom mm:ss.00
 
G

Guest

if it is the text results you could use
=TEXT(A1*0.225,"m")&" minute"&IF(MINUTE(A1*0.225)=1,", ","s,
")&TEXT(A1*0.225,"s")&"seconds"&IF(SECOND(A1*0.225)=1," and ","s and
")&RIGHT(TEXT(A1*0.225,"m:s.00"),2)&" one hundreth of a second"
 

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

separating date and time 5
Calculate the difference between two times - getting '#VALUE!' err 2
Add Seconds to Date - Time Field 2
Date Time increment with additional condition of skipping weekends 13
I need Time Range to return Value 4
How do I convert hours, minutes, and seconds into decimal format? 2
Calculating a Target time from an Actual Time... 2
Conditional Time Calculation 10

Top