On Tue, 5 Jul 2005 14:59:08 -0500, Nikki94
wrote:


Try this one, hope it helps.

=(MONTH(A7)-MONTH(A8))&","&(DAY(A7)-DAY(A8))&","&TEXT(A7-A8,"h:mm")

With:

A7: 01-Mar-2005 00:00
A8: 28-Jan-2005 00:00


Your formula gives:

2,-27,0:00




--ron