Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Cells for Time
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Cells for Time
=A1*0.225
Format cells as: m:ss.00 " wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Cells for Time
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 " wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Cells for Time
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" " wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating time in cells | Excel Discussion (Misc queries) | |||
Number Formating Cells (Time) | Excel Discussion (Misc queries) | |||
TIME FORMATING | Excel Discussion (Misc queries) | |||
Time Formating | Excel Worksheet Functions | |||
change time formating | Excel Discussion (Misc queries) |