First of all switch to the 1904 Date system to enable your sheet to show
negative times.

i would like to create a spread sheet

If you are just creating the sheet then you will be OK but if you have
already any dates in the sheet then note that these will change by four
years and one day.

The Bormula to use to get the time difference is simply:

=B2-A1
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"jkf" wrote in message
...
Hi
i would like to create a spread sheet that would show a time difference
between two cells ie

time due actual time if late
04:00 04:05 ?

this sheet would run for say a week so i would also like to incorporate a
graph,

i have so far managed to get the times ok, but think it needs a bit of
tweaking, as for the graph bit i am totally lost.

tia

jkf