 |
 | 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 / March 2008Calculating Hours
I am looking to calculate hours and minutes. I want to calculate how long something has been running for by adding hours and minutes every week to the total. The problem is it stops counting after about 1000hours. is there a formula to count hours and minutes up to say 10000hours. It I put 500:45:00 in a1 and &00:45:25 in A1 The in A3 =A1+A2, I get 1201:30:25 I do not understand "it stops counting after 1000 hours" please give more details of your worksheet's layout best wishes  SignatureBernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email >I am looking to calculate hours and minutes. > I want to calculate how long something has been running for by adding > hours > and minutes every week to the total. > The problem is it stops counting after about 1000hours. is there a formula > to count hours and minutes up to say 10000hours. |
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.