Hi guys,

I've formatted my cells to 'custom' then 'hh:mm:ss.00' so that bit is fine.
The problem I have is my target time cell could read 00:01:30.00 (which
means no hours, 1 minute, 30 seconds, and no hundreds of a second), and my
actual collumn could read 00:01:00.00 (which is 1 minute).

So in my Difference collumn which is also formatted in hh:mm:ss.00 I have
made the formula:

=IF(Q21=0,"",Q21-P21)

which gives me -0.0003472, clearly not in time.

Then in my difference collumn to display the % of the difference in time, I
have this formula:

=IF(Q21=0,"",Q21/P21)

which gives my difference expressed as a % as 67%.

If the actual is 1 minute and the target was 1 min 30 secs then I've
improved by 30 secs, so I'm not sure if this is 67% as my maths aren't too
good ?! Can I assume this is the right percentage between a minute and a
minute and a half ?

And the second thing is, why is it not expressing the time difference, and
just displaying the -0.0003472 ?!

I hope I've explained it clearly to you. I appriciate your help, thanks a lot!