View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Calculate and Format Time

Enter the data with hours as well, 0:12:12, and so on, then format the sum
cell as [m]:ss

--
__________________________________
HTH

Bob

"Erika" wrote in message
...
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