View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default How do I sum increments of minutes and seconds

You seem to have entered the dates as decimal values. But remember a
minute has 60 seconds, not 100. So 0.28 mintes equals 60/100*28 = 16.8
seconds.

Enter the values as 7:28, 2:38 and 5:48 and it should work. However,
remember that adding up times can never display more than 24 hours!

Hans