Hi Michaela,

Just subtract the first from the later and format the target cell as 'dd
hh:mm'

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michaela" wrote in message
...
I have a tracking sheet that I would like to have one cell that shows the
date and the subtracted time.
(i.e 01/03/05 11:00, 01/04/05 12:00) are my dates I can get it to the
minutes but not the dates. Also, can there be restrictions put on here as
well