More than just time
Try with
=INT(A1)+A2-A1
or
=TEXT(A1,"mm/dd/yy") &" "&TEXT(0,"00\h")&" "&TEXT(MINUTE(A2-A1),"00\m")
--
Regards
Juan Pablo González
"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
|