How do I calculate 1000001 999999
Hours: minutes add over 10000: 01 
author  message  

fuexchen2002 You can freely change the rank in the profile Posted: March 31, 2006, 11:45 pm First name: 
 
rainberg Excel users Posted: 01 Apr 2006, 8:19 am First name: 

You can freely change the rank in the profile
Posted:
01 Apr 2006, 5:23 pm
First name:
Yes, I use the format [hh]: mm and as soon as I start with 9999: 59 I have no problem. But I have to (want to) start with 19227: 34 and then it doesn't work anymore. Greetings Roman 
Excel users
Posted:
01 Apr 2006, 5:42 pm
First name:
Hello Roman, The following is written in the Excel Limitations.

You can freely change the rank in the profile
Posted:
02 Apr 2006, 4:11 pm
First name:
Thank you Rainer for your help. Unfortunately, I can't figure it out very well, but it doesn't matter. I'll find a solution somehow (sooner or later) Greetings Roman 
Beginners
Posted:
04 Apr 2006, 8:27 am
First name:
Place of residence: Moers
Hello fuexchen, try Rainer's hint as follows:  
A.  B.  C.  
1  19227:34  01:23  19228:57 
2  19228:57  01:35  19230:32 
Formulas of the table 
A1: = "9227: 34" + "9000: 00" + "1000: 00" C1: = A1 + B1 A2: = C1 C2: = A2 + B2 
Related topicsForum / Topics reply author Calls last contributionExcel formulas: add values if several conditions are met1wheinrichs1106828 Nov 2005, 12:46
c0bRa Excel formulas: cell reference / automatic addition4AMan150820 Sep 2005, 10:46
guest Excel formulas: calculate time and hours2power user405103 Aug 2005, 10:20 pm
poweruser Excel formulas: Adding cells with text content7Bugera1428Jul 20, 2005 at 8:25 am
rainberg Excel formulas: add hours5tom2ba249007 Jul 2005, 3:51 pm
fridgenep Excel formulas: Timesheet  time calculation (also negative), add up9blademoritz1637807May 19, 2005, 11:47 am
blademoritz16 Excel formulas: time in hours8Julilia479406 Apr 2005, 12:04 pm
fridgenep Excel formulas: add hours and minutes6Cougar47041March 03, 2005, 3:41 pm
Cougar Excel formulas: minutes in decimal number1JochenSR832Feb 18, 2005, 7:23 pm
Arnim Excel formulas: convert hours and minutes into number of working days with remainder13Kim3911Feb 10, 2005, 6:35 pm
Kim Excel formulas: Total calculation of failure in hours per system7twistx1948Jan 27, 2005, 8:58 pm
Thomas Ramel Excel formulas: Will add values in relation to two other columns3Hardy_K_888197102 Dec 2004, 12:00
ae
c0bRa Excel formulas: cell reference / automatic addition4AMan150820 Sep 2005, 10:46
guest Excel formulas: calculate time and hours2power user405103 Aug 2005, 10:20 pm
poweruser Excel formulas: Adding cells with text content7Bugera1428Jul 20, 2005 at 8:25 am
rainberg Excel formulas: add hours5tom2ba249007 Jul 2005, 3:51 pm
fridgenep Excel formulas: Timesheet  time calculation (also negative), add up9blademoritz1637807May 19, 2005, 11:47 am
blademoritz16 Excel formulas: time in hours8Julilia479406 Apr 2005, 12:04 pm
fridgenep Excel formulas: add hours and minutes6Cougar47041March 03, 2005, 3:41 pm
Cougar Excel formulas: minutes in decimal number1JochenSR832Feb 18, 2005, 7:23 pm
Arnim Excel formulas: convert hours and minutes into number of working days with remainder13Kim3911Feb 10, 2005, 6:35 pm
Kim Excel formulas: Total calculation of failure in hours per system7twistx1948Jan 27, 2005, 8:58 pm
Thomas Ramel Excel formulas: Will add values in relation to two other columns3Hardy_K_888197102 Dec 2004, 12:00
ae
 After whom is the USS Nimitz named?
 America will outsource its declarations of war
 What did the wow signal actually contain?
 What prevents hearing loss
 Can I get paid for my poetry?
 Where does the word gringo come from?
 What does U2 think of the Beatles
 What is Moz's Spam Score
 How can I improve my penile erection?
 How did the Alan Turing bomb machine work
 Could paradoxes be viewed as a multiverse theorem
 Should I root my phone?
 Are stairs romantic
 What are different website layout designs
 Why do you like Severus Snape
 What do miracles mean
 What is a good platform for sharing pictures
 The NSA reads this message
 How do I switch bank accounts
 How did the renaissance affect your life?
 Which drug is useful for reducing fat
 Where do the locals eat in New Orleans
 How many VMware workstations under Windows 7
 Have you ever helped a messenger