View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michaela Michaela is offline
external usenet poster
 
Posts: 14
Default More than just time

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