 |
 | 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 and minutes
I am needing to calculate how long an item was used for using hours and minutes. Is there a formula or format that will let me do this. The total will go into thousands of hours. And i cannot have days or seconds, must only be hours and minutes in my spreadsheet. Can anyone help Hi, =B1-A1 format as [hh]:mm earlier date and time In A1 Mike > I am needing to calculate how long an item was used for using hours and > minutes. [quoted text clipped - 4 lines] > > Can anyone help actually i am trying to count hours by adding an amount to my total every 7 days. it started at 0 and is now 200hrs and 30 mins. i want to add how long it was used onto this total every week. It wont let me calculate over say 1000hours > Hi, > [quoted text clipped - 13 lines] > > > > Can anyone help There's no need for another thread, If someone knows the answer you'll get it in the first one. > It wont let me calculate over say 1000hours What does this mean with cells formatted as [hh]:mm I can add up hours in excess of 1000. What formula are you using? As an example all formatted as [hh]:mm a1=1100:58 b1=900:24 c1=A1+b1 gives an answer of 2001:22 Mike > actually i am trying to count hours by adding an amount to my total every 7 > days. it started at 0 and is now 200hrs and 30 mins. i want to add how long [quoted text clipped - 18 lines] > > > > > > Can anyone help sry i meant 10,000:00 this is what i have time ran total time ran A B 1 9975:30 2 57:60 00:00 - this is what it calculates to! it wont let me calculate over 4 figures in hrs and returns the value to zero. i am using format [hh]:mm and formula is =SUM(B1,A2) > There's no need for another thread, If someone knows the answer you'll get it > in the first one. [quoted text clipped - 32 lines] > > > > > > > > Can anyone help Nick, Now I understand you've encountered this http://support.microsoft.com/kb/214386 However, I still don't see your problem because all this means is you cant enter 10000 hours in a cell but you can sum 2 cells to a total in excess of that Mike > sry i meant 10,000:00 > this is what i have [quoted text clipped - 42 lines] > > > > > > > > > > Can anyone help
|
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.