Calculate PHP hour percentage

Question

I need to calculate the percentage of each hour of one array. For example:

Hora1: 4:45 am
Time 2: 1:30 am
Time 3: 00:45
Total: 07:00

$array = array('04:45','01:30','00:45');

I did the calculation in excel, and the result was:

EDIT

Follow the PHP I’m trying, but it’s returning different values:

$array = array('04:45', '01:30', '00:45');
      foreach ($array as $tem => $key) {
      $total = '07:00';
      $tempo = $key;

      $percentual = round(($tempo / $total) * 100);

      $percentual_total .= "Tempo: " . $tempo . ", Percentual: " . $percentual . "<br>";
}

 echo $percentual_total;

Return of PHP

Answer 1

One solution would be this:

// Array com os horários
$array = array('04:45', '01:30', '00:45');

// Array que será armazenado as porcentagens
$porc = array();

// Total em mintuos
$total = 0;

// Varre o array dos horários e converte para inteiro
foreach ($array as $key => $time) {
    sscanf($time, "%d:%d", $hours, $minutes);
    $mins = $hours * 60 + $minutes;
    array_push($porc, $mins);
    $total += $mins;
}

// Converte os inteiros para porcentagem
$porc = array_map(function($value) use ($total) {
    return round(($value / $total) * 100, 2);
}, $porc);

// Exibe os valores
foreach ($array as $key => $time) {
    echo "Tempo: " . $time . ", Percentual: " . $porc[$key] . "%<br>";
}

Answer 2

result - ideone

I transformed $total in minutes and in the foreach at each iteration, the value of the element $key also in minutes to perform the calculations with the same units.

$array = array('04:45', '01:30', '00:45');

$total = '07:00';
$explodeHoraTotal = explode(":",$total); //retorna um array onde cada elemento é separado por ":"
$minutosTotal = $explodeHoraTotal[0];
$minutosTotal = $minutosTotal*60;
$total =$minutosTotal+$explodeHoraTotal[1];

foreach ($array as $tem => $key) {

      $quebraHora = explode(":",$key); //retorna um array onde cada elemento é separado por ":"
      $minutos = $quebraHora[0];
      $minutos = $minutos*60;
      $tot =$minutos+$quebraHora[1];

      $percentual = round(($tot / $total) * 100);

      $percentual_total .= "Tempo: " . $key . ", Percentual: " . $percentual . "<br>";
}

 echo $percentual_total;

---

---

Because your script went wrong?

We should always keep in mind that we can only perform mathematical operations for the same quantity with numbers representing exactly the same unit of measure. You were looking for a mathematical operation involving numbers with two units of measurement, hour and minutes. It could, if it turned into decimal hours, example, (4,5hs/1,5hs) outworking: 3 períodos de 1,5hs

In the code below I transformed the array into decimal hours $array = array('4.75', '1.5', '0.75'); and the total hours as well $total = '7.0';

• decimal hours - example: 4 hours and 45 minutes, in decimals, are 4 hours and 3 quarters of an hour, ie 4.75

That way we can do mathematical operations as can be seen below:

$array = array('4.75', '1.5', '0.75');

$total = '7.0';

 foreach ($array as $tem => $key) {

      $percentual = round(($key / $total) * 100);

      $percentual_total .= "Tempo: " . $key . ", Percentual: " . $percentual . "\n";
}

 echo $percentual_total;

ideone

---

---

Going back to the operations you were wanting to do, we have that PHP simply ignored the hours after the two points including the two points. So 04:45 turned into 4 and '07:00' in 7. Upshot round((4 / 7) * 100); is exactly 57 see in ideone