Thread
:
show time difference
View Single Post
#
6
Posted to microsoft.public.excel.newusers
jkf
external usenet poster
Posts: 12
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
Reply With Quote
jkf
View Public Profile
Find all posts by jkf