Hi
I think Sandy meant to type
=B2-A2
If you don't want to adopt the 1904 date system, then you could convert
all the times to minutes and show the difference as plus or minus the
number of minutes. Excel stores times as fractions of a day, so multiply
by 24 to give hours and by then by 60 to give minutes or multiply by
24*60 = 1440
=(B2-A2)*1440
Format the ell with the formula as General or Number.
As far as graphing is concerned, if the dates fro these transactions
were held in column D, then mark the range of values in C and D, Press
F11. This will produce a Chart on a new sheet.
Right click on the Chart and choose Source Data
Series tabSelect Series 2Ctrl X to cut the range from the Values
boxmove to Category (X) axis labelsCtrl V to Paste.
--
Regards
Roger Govier
"Sandy Mann" wrote in message
...
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