Hi,

Am Wed, 14 Nov 2012 08:35:06 -0800 (PST) schrieb :

Your solution works for those situations that occur over a short period, say 1 day.
Over a multiple day situation it is giving me a problem. The period between 10/29/12 19:33 and 11/8/12 15:40 gives me an elapsed time of 20:07.
Also when I sum up the elapsed time column I do not get a meaningful value.

as Joe wrote, you have to format the cell [h]:mm


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2