Time Questions

[Sharif]

Hello All,

I have a variable formatted like so:

$start_time = $_POST['start_hour'] . ':' . $_POST['start_minute'] . ':00';
$start_ampm = $_POST['start_ampm']; //specifies if start time is in AM or PM

$end_time = $_POST['start_hour'] . ':' . $_POST['start_minute'] . ':00';
$end_ampm= $_POST['end_ampm']; //specifies if end time is in AM or PM

How would I prepare that into a 24 hour format so I can insert into a MySQL database field? I know I can do it using switch() manually but is there a way to automate it?

Also, does anyone know how to calculate the difference in two time variables (as seen above)?

[scrupul0us]

$start_time = $_POST['start_hour'] . ':' . $_POST['start_minute'] . ':00 ';
$start_time .= $_POST['start_ampm']; //specifies if start time is in AM or PM
$start_time = date('G:i:00',strtotime($start_time));

$end_time = $_POST['start_hour'] . ':' . $_POST['start_minute'] . ':00 ';
$end_time .= $_POST['end_ampm']; //specifies if end time is in AM or PM
$end_time = date('G:i:00',strtotime($end_time));

$diff = strtotime($end_time) - strtotime($start_time); 

[Chemist]

Not sure if this is exactly what you're asking for but see if this helps.

$_POST['start_ampm'] = 'AM';
$_POST['start_hour'] = 6;
$_POST['start_minute']  =  42 ;

$_POST['end_ampm']  = 'PM';
$_POST['end_hour'] = 11;
$_POST['end_minute']  =  7 ;

if(trim($_POST['start_ampm']) == "AM" ) {
    $start_ampm = 'AM' ;
    $start_time = $_POST['start_hour']  . ':' . $_POST['start_minute'] . ':00';
}
else{
    $start_ampm = 'PM' ;
    $start_time = $_POST['start_hour']  + 12 . ':' . $_POST['start_minute'] . ':00';
}

if(trim($_POST['end_ampm']) == "AM" ) {
    $end_ampm = 'AM' ;
    $end_time = $_POST['end_hour'] . ':' . $_POST['end_minute'] . ':00';
}
else{
    $end_ampm = 'PM' ;
    $end_time = $_POST['end_hour']  + 12 . ':' . $_POST['end_minute'] . ':00';
}

echo "<br><br>\$start_time = $start_time<br>\$end_time = $end_time<br>"; 

$time_diff = strtotime($end_time) - strtotime($start_time) ;
echo "<br> " ,floor($time_diff/60/60) ," Hours";
echo "<br> " ,floor($time_diff/60) - 60*(floor($time_diff/60/60))," Minutes<br><br><br>";