[RESOLVED] Number Format

TheCase

Hi,

This is my input
25670
35240

I would like to output it like this
0:25:67
0:35:24

How can I do this, thanks

NogDog

If the value was 34567, would the output be 0:34:56, 0:34:57 (rounded), or 7:34:56 (or something else)?

TheCase

34567 Would be 3:45:67

Thanks

NogDog

TheCase;10891309 wrote:
34567 Would be 3:45:67

Thanks

OK, I'm still not seeing the pattern or logic here. Why is 34567 formatted as 3:45:67 while 23450 would apparently be 0:23:45 (instead of 2:34:50)?

TheCase

Its aa:bb:cc

a Minutes
b Seconds
c Milliseconds

Work backwards so for example
35240

cc - 24 (ignore the 0)
bb - 52
a - 03 (add an 0)

Hope this is clear

NogDog

Sorry if I'm being dense here and making this more complicated than it is, but I'm not grasping why you "ignore the 0" for the right-most digit but apparently do not ignore it if it is non-zero. Without understanding what the initial value represents, I don't know whether some sort of numeric or date/time algorithm is needed, or if it should simply be treated as a string operation (such as using the [man]substr/man function).

TheCase

Im fetching data from a file made by a game I play so I didnt really make the time format if I did it would be much simpler, im just guessing really its echoing back 25670 then when I launch the file the time is 0:25:67 hope this helps

NogDog

All I can suggest then without really knowing the origin of the string is:

<?php
$var = '12340';
$var = substr_replace(substr($var, 0, -1), ':', 2, 0);
echo $var;

TheCase

Thanks for trying but its not working. 25670 is outputting as 25:67 but it should be 00:25:67 but we could get 0125670 01:52:67

Any ideas,
Thanks

NogDog

<pre><?php
function formatNbr($nbr)
{
   list($hr,$min,$sec) = str_split(sprintf('&#37;06d', substr($nbr, 0, -1)),2);
   return $hr.':'.$min.':'.$sec;
}
$testData = array('1230', '12340', '123450', '1234560');
foreach($testData as $test)
{
   echo formatNbr($test)."\n";
}
?></pre>

TheCase

Works great thanks alot

TheCase

Fatal error: Cannot redeclare formatnbr()

How can I redclare it, I have many times i want to display in this format on a page

Thanks

Weedpacket

How can I redclare it

You don't. You only need to declare it once (the "function formatNbr($nbr){....}" bit) and then use it as often as you need. That's the idea of functions.

TheCase

sorry im new to this can you point me in the right direction

function formatNbr($formatreplaytime2)
{
   list($hr,$min,$sec) = str_split(sprintf('%06d', substr($formatreplaytime2, 0, -1)),2);
   return $hr.':'.$min.':'.$sec;
}
$timeformat = $row['time'];
$testData = array("$timeformat");
foreach($testData as $test)
{
   $formatreplaytime = formatNbr($test)."\n";
   $formatreplaytime4 = formatnbr();
}

echo '
<tr>
<td align="left"><p>' . $row['track'] . ' </p></td>
<td align="left"><p>' . $formatreplaytime4 . ' </p></td>
<td align="left"><p>' . $row['username'] . ' </p></td>
<td align="left"><a href="upload.php?id=' . $row['id'] . '">Upload</a></td>
<td align="left"><a href="./replays/' . $row['download'] . '">Download</a></td>
	</td>
	 </tr>
';

thanks

Weedpacket

I'm guessing that this is inside a loop that generates each row of a table. Move the function declaration out of that loop.