Assuming both dates are always the same you could try something like

=TEXT(FLOOR(A1,1),"mm/dd/yyyy") & " " & TEXT(B1-A1,"hh:mm")

Tim




"Michaela" wrote in message
...
I am trying to create a tracking sheet.

In cell A1 I have 01/03/05 03:30 pm
In Cell B1 I have 01/03/05 03:35 pm
In cell C1 I want to get the answer 01/03/05 00hrs 05mins
So far I can get the minutes,but how do I get the date?

Right now all can it to do is give me 01/00/00 00hrs 05mins