View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] Steven_Phillips77@hotmail.com is offline
external usenet poster
 
Posts: 2
Default 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?