Adding up the total time more than 24 hours

[AHMEDSOIB]

<table width="64" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 63.75pt;" height="85"> <td valign="top">
</td><td class="xl65" style="height: 63.75pt; width: 48pt;" width="64" height="85">Relative time bw stations</td> </tr> <tr style="height: 12.75pt;" height="17"> <td valign="top">
</td><td class="xl63" style="height: 12.75pt;" align="right" height="17">0:00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td valign="top">
</td><td class="xl63" style="height: 12.75pt;" align="right" height="17">0:12</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">1:05</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:38</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:29</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:09</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:20</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:32</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:13</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:27</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:28</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">1:42</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">1:10</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">3:05</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">2:40</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl63" style="height: 18pt;" align="right" height="24">0:40</td> </tr> <tr style="height: 22.5pt;" height="30"> <td valign="top">
</td><td class="xl63" style="height: 22.5pt;" align="right" height="30">0:30</td> </tr> <tr style="height: 18pt;" height="24"> <td valign="top">
</td><td class="xl64" style="height: 18pt;" align="right" height="24">14:20

The time is adding up ok upto 24 hours but once it crosses the 24 hour mark its showing me 1, 2, 3 I want the total time taken to travel by train where the above timings is the time taken from 1 station to next station.

If someone can help if they are not getting what i want i can post the xcel sheet iam working with but i dont know how to attach the file here.
​

</td> </tr> </tbody></table>

 

[dave3009]

I think you're looking to use a custom format of [h]:mm:ss

 

[AHMEDSOIB]

Mine is Windows XP, excel 2007 Version.

Yes my cell format is custom hh:mm, but what i want is to sum the total time take for eg it will take 36 hours from a to b and the time between stations are given as i have shown in my earlier post but when iam summing it up now the time is within 23 hours and 59 minutes its showing it up well, once the time crosses 24 hour mark its showing the sum as 1:01,2;01,3:01 rather than showing 25:01, 26:01, 27:01 ...... so on and so forth.

 

[dave3009]

Not format hh:mm, format [h]:mm

See here

Excel Workbook
	A	B
1	hh:mm	[h]:mm
2	02:30	26:30
3	00:22	48:22
Sheet3

Excel 2007

Cell Formulas
Range	Formula
B2	=A2

 

[AHMEDSOIB]

Thanks boss I have got the answer you rock!

Not format hh:mm, format [h]:mm

See here

Excel Workbook
	A	B
1	hh:mm	[h]:mm
2	02:30	26:30
3	00:22	48:22
Sheet3

Excel 2007

Cell Formulas
Range	Formula
B2	=A2

 

[mysterious-dr-x]

I think its probably best to revive this thread rather than create a new one.

My problem is that the custom format of [h]:mm is not doing what it is supposed to. I am instead getting the following;


<table border="0" cellpadding="0" cellspacing="0" height="132" width="170"><col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <tbody><tr style="height:15.75pt" height="21"> <td class="xl65" style="height:15.75pt; width:62pt" align="center" height="21" width="82">DAILY</td> <td class="xl66" style="border-left:none;width:66pt" width="88">CUMULATIVE</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl69" style="height:15.75pt;border-top:none" align="center" height="21">07:15</td> <td class="xl71" style="border-top:none;border-left:none" align="center">295:15</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl69" style="height:15.75pt;border-top:none" align="center" height="21">07:35</td> <td class="xl71" style="border-top:none;border-left:none" align="center">600:26</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl69" style="height:15.75pt;border-top:none" align="center" height="21">07:45</td> <td class="xl71" style="border-top:none;border-left:none" align="center">896:11</td> </tr> <tr style="height:15.75pt" height="21"> <td class="xl69" style="height:15.75pt;border-top:none" align="center" height="21">08:09</td> <td class="xl71" style="border-top:none;border-left:none" align="center">1201:56</td> </tr> <tr style="height:16.5pt" height="22"> <td class="xl70" style="height:16.5pt;border-top:none" align="center" height="22">05:06</td> <td class="xl72" style="border-top:none;border-left:none" align="center">1495:02</td> </tr> </tbody></table>
...what the hell has happened here?

 

[Endosmok]

I think its probably best to revive this thread rather than create a new one.

My problem is that the custom format of [h]:mm is not doing what it is supposed to. I am instead getting the following;


[TABLE="width: 170"]
<colgroup><col width="82" style="mso-width-source:userset;mso-width-alt:2998;width:62pt"> <col width="88" style="mso-width-source:userset;mso-width-alt:3218;width:66pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 82, align: center"]DAILY[/TD]
[TD="class: xl66, width: 88"]CUMULATIVE[/TD]
[/TR]
[TR]
[TD="class: xl69, align: center"]07:15[/TD]
[TD="class: xl71, align: center"]295:15[/TD]
[/TR]
[TR]
[TD="class: xl69, align: center"]07:35[/TD]
[TD="class: xl71, align: center"]600:26[/TD]
[/TR]
[TR]
[TD="class: xl69, align: center"]07:45[/TD]
[TD="class: xl71, align: center"]896:11[/TD]
[/TR]
[TR]
[TD="class: xl69, align: center"]08:09[/TD]
[TD="class: xl71, align: center"]1201:56[/TD]
[/TR]
[TR]
[TD="class: xl70, align: center"]05:06[/TD]
[TD="class: xl72, align: center"]1495:02[/TD]
[/TR]
</tbody>[/TABLE]

...what the hell has happened here?

I've ran into the same issue as quoted above. My AUTOSUM works fine until it gets passed 24 total. So I've tried the custom format's I've located on the internet and even the one outline on the Microsoft website.

[hh]:mm;@
also tired [hh]:mm

whenever I use those brackets (which is suppose to be the solution) it get enormous numbers as shown above with the set of my numbers. I can't figure out why this is so....

I know this is an old thread but I just ran into this issue. Any suggestions?