How do I add time (in mm:ss) from multiple worksheets?
 

I'm trying to add times in mm:ss that sources from multiple worksheets. Help?

Dear Stumped

The smallest increment that excel will accept is hh:mm:ss so even if
you are entering 15min 35 sec, you still have to enter the hours thus:
00:15:35

As long as you make certain that all the cells that contain your times
are formatted the same way, there should not be a problem. Where things
start going awry is once you get to 60 minutes and above. If you want to
have the sum expressed as minutes (regardless of how many, then the
format you need has the mm in square brackets thus: [mm]:ss

Cheers
Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=398861