 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007show 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 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  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Hi > i would like to create a spread sheet that would show a time difference [quoted text clipped - 12 lines] > > jkf 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. SignatureRegards Roger Govier > First of all switch to the 1904 Date system to enable your sheet to > show negative times. [quoted text clipped - 24 lines] >> >> jkf > I think Sandy meant to type > =B2-A2 Yes and Sandy meant to type Formula as well not Bormula! <g> SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Hi > [quoted text clipped - 44 lines] >>> >>> jkf Didn't like to point that out as well Sandy!! <bg> SignatureRegards Roger Govier >> I think Sandy meant to type >> =B2-A2 [quoted text clipped - 49 lines] >>>> >>>> jkf thank for your input, now got what i wanted thanks all jkf > Didn't like to point that out as well Sandy!! <bg> > [quoted text clipped - 51 lines] >>>>> >>>>> jkf
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.