 |
 | 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 / May 2008How many hours/minuts between two clocks ?
I have two cells, each one have a clock in it, like 14:30 and 22:00 Now I want to calculate how many hours/minuts there is between the two clocks, and the result to be showed in a third cell. How can I do this ? In A1 u have 14:30 & B1 = 22:00, Put C1 =IF(A1>B1,A1-B1,B1-A1) then for the C1 set the number format [h]:mm > I have two cells, each one have a clock in it, like 14:30 and 22:00 > Now I want to calculate how many hours/minuts there is between > the two clocks, and the result to be showed in a third cell. > > How can I do this ? Bonsour® SpookiePower avec ferveur ;o))) vous nous disiez : > I have two cells, each one have a clock in it, like 14:30 and 22:00 > Now I want to calculate how many hours/minuts there is between > the two clocks, and the result to be showed in a third cell. > > How can I do this ? =ABS(A1-B1)  Signature-- @+ ;o))) With the first time in A1 and the second time i A2 try: =MOD(A2-A1,1) This will work even if the times cross midnight. 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 >I have two cells, each one have a clock in it, like 14:30 and 22:00 > Now I want to calculate how many hours/minuts there is between > the two clocks, and the result to be showed in a third cell. > > How can I do this ? > With the first time in A1 and the second time i A2 try: > > =MOD(A2-A1,1) > > This will work even if the times cross midnight. Thanks to all of you, but I can't get it to work. The only thing that works for me is this - =A2-A1 But it do not works if the times cross midnight. I have set the cell format to hh:mm. I don't know why the MOD() function would not work if both times are XL times formatted to hh:mm Try: =A2-A1+(A2<A1) which also will cross midnight. 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 >> With the first time in A1 and the second time i A2 try: >> [quoted text clipped - 9 lines] > But it do not works if the times cross midnight. > I have set the cell format to hh:mm. > Try: > > =A2-A1+(A2<A1) It works, thanks :) Glad that you got it to work. Thanks for the feedback. SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >> Try: >> >> =A2-A1+(A2<A1) > > It works, thanks :) |
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.