View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default 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