Re Target Times

[Bill]

Thanks everyone Reference Thread preceding this text
Background
I need to show a minus figure in the total if the result
is better than target
ie target (c40) is 15:00 mins. Achieved (b1)is 12:00 mins
so result is -03:00 mins i.e. 3 minutes under target.

This will be graphed with target of 15 mins as the base
line "zero" with the y axis showing the minutes over
target above the base line and minutes under target
(better than target) below the base line zero.
example
mins (- = better than target)
+5
+4
+3
+2 *
+1 *
0------------------------------------- target
-1 *
-2
-3 *

day1 day2 day3 day4

Bob Phillips & Biff's respopnses & example of conditional
formatting gave results to an extent but not in the
-03:00 which I need. I don't think I was quite clear
enough. "Tod" said it couldn't be done.
Thanks everyone but if my message has made it clearer and
some brilliant person can help I would be very grateful
Thanks
Bill

---Original Message-----

 

[Bob Phillips]

or even

=IF(F1>G1,"-","")&TEXT(ABS(G1-F1)*24,"@")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)