show time difference

[jkf]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Roger Govier]

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 tab>Select Series 2>Ctrl X to cut the range from the Values
box>move to Category (X) axis labels>Ctrl V to Paste.

 

[Sandy Mann]

I think Sandy meant to type

=B2-A2

Yes and Sandy meant to type Formula as well not Bormula! <g>

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Roger Govier]

Didn't like to point that out as well Sandy!! <bg>

 

[jkf]

thank for your input,

now got what i wanted

thanks all

jkf