| 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? |
| 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) | |||
Threaded Mode
