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
|