View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erika Erika is offline
external usenet poster
 
Posts: 120
Default Calculate and Format Time

I am trying to calculate time and I am not sure if I have them listed in the
appropriate format. I need them in a minute and second format. I want to
add up the following and get the total in a minute and second format as well
then in another cell I want to multiple the total minutes by 3.

12:12
13:02
11:03
12:03
23:23
12:34