How to get the format in hours when it exceeds 24?

Question

I’m developing a PHP system where I need to get the total time of an audio file at some point. This time is saved in the database in seconds and also in the format of hours.

The problem is that when you format these hours through the seconds saved in the bank, it works normally, but only if the file has the time less than 24 hours.

Example:

$date = new DateTime('@0'); // "zeramos" a data

$tempo_1 =  10 * 3600; // 10 horas

$tempo_2 = 18 * 3600; // 18 horas

$tempo_3 = 28 * 3600; // 28 horas


echo $date->setTime(0, 0, $tempo_1)->format('H:i:s'); // 10:00:00

echo $date->setTime(0, 0, $tempo_2)->format('H:i:s'); // 18:00:00

echo $date->setTime(0, 0, $tempo_3)->format('H:i:s'); // 04:00:00

In the last example, the desired result was 28:00:00. However, since it is a class that works with dates, it is returned 04:00:00, on behalf of 24 equal to 1 day.

How could I get that time formatted in hours, even if this exceeds 24 hours?

Answer 1

The solutions presented above are very good.

However, even if it seems stupid, I discovered another solution to this problem using the function SEC_TO_TIME of Mysql.

Behold:

SELECT SEC_TO_TIME( 28 * 3600 )
--28:00:00

So, for the record, if anyone has a problem like this!

It seems at this point, the Mysql simplified things much more than PHP itself.

Updating

I’ve developed a library so we can work with the times more precisely. And I used some of the solutions applied here in the source code.

Care:

https://github.com/wallacemaxters/timer

Answer 2

Note: In case the author solved using Mysql, then this answer may to chance data coming from another "source" where it does not have a resource similar to SEC_TO_TIME.

If the time format is in seconds you can calculate using PHP without the need for "advanced" classes for this, as the example of this reply in Soen

I just made an adjustment so that broken numbers are supported, using the function fmod()

The code went like this:

<?php
function getFullHour($seconds) {
    $negative = $seconds < 0; //Verifica se é um valor negativo

    if ($negative) {
        $seconds = -$seconds; //Converte o negativo para positivo para poder fazer os calculos
    }

    $hours = $seconds / 3600;

    $mins = ($seconds - ($hours * 3600)) / 60;

    //Pega o valor após o ponto flutuante
    $f = fmod($hours, 1);

    //Adiciona minutos se $seconds for quebrado
    if ($f > 0) $mins += 60 * $f;

    $secs = $seconds % 60;

    $sign = $negative ? '-' : ''; //Adiciona o sinal de negativo se necessário

    return $sign . sprintf('%02d:%02d:%02d', $hours, $mins, $secs);
}

echo getFullHour(3.002 * 60 * 60), PHP_EOL; //03:00:07
echo getFullHour(3.5 * 60 * 60), PHP_EOL; //03:30:00

echo getFullHour(3 * 60 * 60), PHP_EOL; //03:00:00

echo getFullHour(140801), PHP_EOL; //39:06:41
echo getFullHour(100800), PHP_EOL; //28:00:00

echo getFullHour(-140801), PHP_EOL; //-39:06:41
echo getFullHour(-100800), PHP_EOL; //-28:00:00

Online test on repl it.

Answer 3

I don’t recommend it, but you can do a little snitching:

function dtLength($sec) {
    $t=new DateTime("@".$sec);
    $r=new DateTime("@0");
    $i=$t->diff($r);
    $h=intval($i->format("%a"))*24+intval($i->format("%H"));
    return $h.":".$i->format("%I:%S");
}

$date = new DateTime;
$tempo_1 =  10 * 3600; // 10 horas
$tempo_2 = 18 * 3600; // 18 horas
$tempo_3 = 28 * 3600; // 28 horas
echo $date->setTime(0, 0, $tempo_1)->format('H:i:s'); // 10:00:00
echo $date->setTime(0, 0, $tempo_2)->format('H:i:s'); // 18:00:00
echo $date->setTime(0, 0, $tempo_3)->format('H:i:s'); // 04:00:00
echo dtLength($tempo_1);
echo dtLength($tempo_2);
echo dtLength($tempo_3);

Behold working in the ideone. And in the repl it.. Also put on the Github for future reference.

Function withdrawn of that response in the OS.

Another possibility is to work with DateInterval. This type shows times, which is what you seem to be wanting to use, rather than hours. It’s probably more appropriate for what you want.

Answer 4

First we need to understand two important concepts. Consider the two sentences below:

• the film will be shown at two o'clock in the morning
• the film is two hours long

In the first case, "two hours" refers to timetable (a specific moment of the day). It’s okay that he needs "morning" not to be ambiguous (it could be 2 in the afternoon), but the fact is that he is referring to a specific moment.

In the second case, "two hours" refers to duration (an amount of time). It is not said what time the movie starts, nor will it pass or already has passed. It’s just the amount of time, unrelated to schedules.

These two concepts are not the same thing. Dates and times refer to points in the timeline: a date (day, month and year) refers to a specific point in a calendar, and a time (time, minute, second, fractions of a second) refers to a specific time of a day. Durations are just amounts of time, which exist by themselves, without being tied to a specific date and time.

What confuses is the fact that both (both times and durations) use exactly the same words (days, hours, minutes, etc.), and are often written in the same way (a clock shows "02:00:00" when it is two in the morning, a stopwatch shows "02:00:00" when the time count reaches two hours).

Another point that can - erroneously - make us think that times and durations are the same thing is that, although they are different concepts, they may be related. If I calculate the difference between two dates, the result is a duration (knowing the date/time that started and ended, I can calculate how long it lasted), and if I add a date/time with a duration, the result is another date/time (knowing the date/time that started and how long it lasted, I can calculate the date/time that ended).

---

That said, a DateTime to work with dates and times (points in the timeline), but not with durations.

To work with durations, you can use a DateInterval. With it you can create an instance that corresponds to a certain amount of time, and format it through the method format. Ex:

$tempo_1 = new DateInterval('PT10H'); // duração de 10 horas
$tempo_2 = new DateInterval('PT18H'); // duração de 18 horas
$tempo_3 = new DateInterval('PT28H'); // duração de 28 horas

$formato = '%H:%I:%S';
echo $tempo_1->format($formato); // 10:00:00
echo $tempo_2->format($formato); // 18:00:00
echo $tempo_3->format($formato); // 28:00:00

Note that the format used is different from the one used in method format of a DateTime. To a DateInterval, besides the letters need to have the % before, some are different (for example, to format the DateTime, use the i minuscule for the minutes and the s tiny for seconds, but for a DateInterval one should use I and S uppercase so they have zero left for values less than 10).

Another detail is that the builder of DateInterval receives a duration in ISO 8601 format. Basically, the P at the beginning is mandatory (comes from the English "Period", another name for "amount of time"). The T indicates that the following fields refer to hours, minutes and seconds (as before the T we can have fields for days, months and years - for example, P2Y3MT10H5M is a duration of 2 years, 3 months, 10 hours and 5 minutes).

---

In case you only have the total amount of seconds, it wouldn’t do any good new DateInterval("PT{$segundos}S"), since this class does not transform the total amount of seconds into hours, minutes and seconds (PT120S - 120 seconds - is formatted as 00:00:120, and not as 00:02:00). In this case, you would have to manually calculate the hours, minutes and seconds (as suggested in reply from Guilherme Nascimento) and then create the DateInterval. Ex:

$seconds = 100800;
// calcular manualmente as horas, minutos e segundos (versão simplificada da resposta do Guilherme Nascimento)
$hours = floor($seconds / 3600);
$mins = floor(($seconds - ($hours * 3600)) / 60);
$secs = floor($seconds % 60);

$tempo_1 = new DateInterval("PT{$hours}H{$mins}M{$secs}S");
echo $tempo_1->format('%H:%I:%S'); // 28:00:00

Although in this case, it seems an exaggeration to use DateInterval, because you have already calculated each field separately and just print them.

The documentation also suggests other alternatives to turn 100800 seconds in 28 hours, such as this (which uses a logic similar to maniero’s response, to use a DateTime to get another DateInterval), or that one (which makes the calculations similar to reply from Guilherme Nascimento). Unfortunately, DateInterval does not make this conversion natively.