I have created a Report that shows the total amount of time. My problem is that if I have minutes which are not a double digit the time is displayed as 00:1. How do i make it such that the time displays as 00:01 if the minute variable is less than 10? See table in image below:
variables:
// Oliver Block Hours
$result = mysqli_query($conn, "SELECT SUM(flt_hrs) AS value_sum FROM college WHERE (captain ='ot1olivertavares' OR examiner ='ot1olivertavares' OR safetyfirst ='ot1olivertavares' OR firstofficer ='ot1olivertavares') and thedate between '2024-07-01' AND '2024-07-31'");
$row = mysqli_fetch_assoc($result);
$olivert1totalfltjuly = $row['value_sum'];
$result = mysqli_query($conn, "SELECT SUM(flt_min) AS value_sum FROM college WHERE (captain ='ot1olivertavares' OR examiner ='ot1olivertavares' OR safetyfirst ='ot1olivertavares' OR firstofficer ='ot1olivertavares') and thedate between '2024-07-01' AND '2024-07-31' ");
$row = mysqli_fetch_assoc($result);
$olivert1totalfltminjuly = $row['value_sum'];
I have tried the below:
<td><?php echo $olivert1totalfltjuly+(int)($olivert1totalfltminjuly/60). ':'. $olivert1totalfltminjuly%60 ?> </td>