Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show % Difference between two numbers | Excel Discussion (Misc queries) | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
calculating difference, but if condition not met show value given | Excel Worksheet Functions | |||
what is the formula to show the difference between two dates | Excel Discussion (Misc queries) | |||
Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) |