show time difference
 

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

show time difference
 

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

show time difference
 

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

show time difference
 

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


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


"Roger Govier" wrote in message
...
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

show time difference
 

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

--
Regards

Roger Govier


"Sandy Mann" wrote in message
...
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


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


"Roger Govier" wrote in message
...
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

show time difference
 

thank for your input,

now got what i wanted

thanks all

jkf


"Roger Govier" wrote in message
...
Didn't like to point that out as well Sandy!! <bg

--
Regards

Roger Govier


"Sandy Mann" wrote in message
...
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


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


"Roger Govier" wrote in message
...
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