MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do you display more than 60 seconds?


Posted by Ross on December 18, 2001 2:30 AM

Hello,
I am trying to add several times together which are in ss.00 format (seconds and hundredths of seconds), but instead of 40.00 + 40.00 = 80.00 (which is what I want) it gives the result 20.00.

Can anyone help please?
Thanks


Posted by Mudface on December 18, 2001 3:31 AM

Format the cell the result is in as [ss].00, to give the number of seconds elapsed.

Posted by Ross on December 18, 2001 3:53 AM

Thanks Mudface : )