Time or Time interval conversion with PHP

Question

i have the below given time interval options in a dropdown (those are strings)

<select name="CSSAtapsClient[client_time_window][0]" id="client_time_window_0">
<option value="5702">7am - 10am</option>
<option value="5703">10am - 1pm</option>
<option value="5704">12pm - 3pm</option>
<option value="5705">3pm - 6pm</option>
<option value="5706">6pm - 9pm</option>
<option value="5707">7pm - 10pm</option>
<option value="5708">9pm - 12am</option>
<option value="5709">12am - 7am</option>
</select>

I need to convert these intervals for a specific GMT time zone. for example lets say its in GMT +8 and i need to convert it to GMT +10 and it can be done by adding 2 hours.

so if the given time interval is, 7am - 10am (GMT +8) it should come as 9am - 12pm (GMT +10)

What is the best way to convert this kind of a time interval ? The issue i am seeing here is its a string (time interval).

Appreciate an early reply.

EDIT 1

I am converting to only Australian states so there is no chance of getting a day as difference when converting. pls check this link http://www.timebie.com/tz/australiatimezone.php

what these time representing? how you get them? just note that according to time zone difference you might get differences in days also — Jason OOO, Sep 30 '13 at 11:42
@JasonOOO Yes, i forgot to mention that i am doing conversion only for Australian States. so its mostly like 1 or 2 hours change. pls check this link http://www.timebie.com/tz/australiatimezone.php — dev1234, Sep 30 '13 at 11:58

Dalım Çepiç · Accepted Answer · 2013-09-30T15:10:27.800

Try this functions. (Based on your edit i made $to_gmt var of my gmt_to_gmt function default value is "GMT +10")

    <?php

        function is_am_pm($str){
            if(strpos($str, "am") !== false || strpos($str, "AM") !== false) return "am";
            if(strpos($str, "pm") !== false || strpos($str, "PM") !== false) return "pm";
        }
        function get_only_int($str){
            if(strpos($str, ".") !== false){
                if(preg_match_all("/\s(.*?)\.(.*?)$/", $str, $matches))
                    return trim(trim($matches[0][0]),"+");

            }else{
                return (int) preg_replace('/\D/', '', $str);
            }
        }
        function gmt_to_gmt($str,$from_gmt,$to_gmt = "GMT +10"){
            if(!is_numeric($from_gmt)) $from_gmt = get_only_int($from_gmt);
            if(!is_numeric($to_gmt)) $to_gmt = get_only_int($to_gmt);

            $temp_time = explode("-",$str);

            $begin_time_s   = is_am_pm($temp_time[0]);
            $begin_time     = get_only_int(trim($temp_time[0]));
            $end_time_s     = is_am_pm($temp_time[1]);
            $end_time       = get_only_int(trim($temp_time[1]));


            $time_diff  = $to_gmt - $from_gmt;

            $begin_time = $begin_time + $time_diff;
            $end_time   = $end_time + $time_diff;

            if($begin_time > 11){
                if($begin_time_s == "am"){
                    $begin_time >= 12 && $begin_time < 13 ? $begin_time : $begin_time -= 12;
                    $begin_time .= "pm";  
                }else{
                    $begin_time >= 12 && $begin_time < 13 ? $begin_time : $begin_time -= 12;
                    $begin_time .= "am";  
                }
            }else{
                $begin_time .= $begin_time_s;
            }

            if($end_time > 11){

                if($end_time_s == "am"){
                    $end_time >= 12 && $end_time < 13 ? $end_time : $end_time -= 12;
                    $end_time .= "pm";  
                }else{
                    $end_time >= 12 && $end_time < 13 ? $end_time : $end_time -= 12;
                    $end_time .= "am";  
                }
            }else{

                $end_time .= $end_time_s;
            }

            return $begin_time . " - " . $end_time;
        }
        echo gmt_to_gmt("11am - 10pm", "GMT +0" , "GMT +2.5"); 
    ?>

Have a nice day

It's my bad, sorry. I corrected my post. if($begin_time > 12 (not 13)) — Dalım Çepiç, Sep 30 '13 at 12:39
another thing is there. when i give the input as 10am.. its giving me 12am which actually should be 12pm. echo gmt_to_gmt("10am - 11pm", "GMT +0" , "GMT +2"); // 12am - 1am . appreciate your prompt reply. you almost saved my day! — dev1234, Sep 30 '13 at 13:23
Ok. the code is changed. First One is ' $end_time > 11 ' The second one is 'end_time == 12 ? $end_time : $end_time -= 12'; — Dalım Çepiç, Sep 30 '13 at 13:44
echo gmt_to_gmt("11am - 11pm", "GMT +0" , "GMT +2.5"); provides an invalid data. i think i should debug and find out whats causing this issue. anyway tnx a lot for coming this far. it should be a small issue i guess. results was 24pm - 24am when "GMT +2.5". is it only taking integers not doubles ? — dev1234, Sep 30 '13 at 14:28
get_only_int function is rewrited. Now , you can calculate gmt 2.5 . And i changed the code. You are welcome — Dalım Çepiç, Sep 30 '13 at 15:12
i also made it work by altering that function. function get_only_int($str){ return preg_replace('/^\D*/', '', $str); } — dev1234, Sep 30 '13 at 15:32

score 1 · Answer 2 · answered Sep 30 '13 at 17:02

My completed answer.

<?php

function is_am_pm($str) {
   if (strpos($str, "am") !== false || strpos($str, "AM") !== false)
      return "am";
   if (strpos($str, "pm") !== false || strpos($str, "PM") !== false)
      return "pm";
}

function get_only_int($str) {
   if (strpos($str, ".") !== false) {
      if (preg_match_all("/\s(.*?)\.(.*?)$/", $str, $matches))
         return trim(trim($matches[0][0]), "+");
   }else {
      return (int) preg_replace('/\D/', '', $str);
   }
}

function gmt_to_gmt($str, $from_gmt, $to_gmt = "GMT +10") {
   if (!is_numeric($from_gmt))
      $from_gmt = get_only_int($from_gmt);
   if (!is_numeric($to_gmt))
      $to_gmt = get_only_int($to_gmt);

   $temp_time = explode("-", $str);

   $begin_time_s = is_am_pm($temp_time[0]);
   $begin_time = get_only_int(trim($temp_time[0]));
   $end_time_s = is_am_pm($temp_time[1]);
   $end_time = get_only_int(trim($temp_time[1]));


   $time_diff = $to_gmt - $from_gmt;
   $begin_time = $begin_time + $time_diff;
   $end_time = $end_time + $time_diff;

   if ($begin_time > 11.59) {
      if ($begin_time_s == "am") {
         $begin_time >= 12 && $begin_time < 13 ? $begin_time : $begin_time -= 12; // 13.3 - 12
         $begin_time .= "pm";
      } else {
         $begin_time >= 12 && $begin_time < 13 ? $begin_time : $begin_time -= 12;
         $begin_time .= "am";
      }
   } else {
      $begin_time .= $begin_time_s;
   }

   if ($end_time > 11.59) { // 11.3
      if ($end_time_s == "am") {
         $end_time >= 12 && $end_time < 13 ? $end_time : $end_time -= 12;
         $end_time .= "pm";
      } else {
         $end_time >= 12 && $end_time < 13 ? $end_time : $end_time -= 12;
         $end_time .= "am";
      }
   } else {
      $end_time .= $end_time_s;
   }

   return format_string($begin_time)." - ".format_string($end_time);
}

function format_string($str) {
   $temp_am_pm = is_am_pm($str);
   $str = (float) preg_replace('/^\D*/', '', $str);
   $val = '';

   if (is_int($str))
      $val = sprintf("%02s", $str);

   else if (is_float($str))
      $val = str_pad(sprintf("%0.2f", $str), 5, '0', STR_PAD_LEFT);

   return $val.$temp_am_pm;
}
echo gmt_to_gmt("12am - 1pm", "GMT +0", "GMT +2.30");

?>

Output - 02.30pm - 03.30pm

@DalımÇepiç why do you think this cannot be achieved with php's internal time conversation methods ? check this.. http://stackoverflow.com/questions/1665702/time-calculation-in-php-add-10-hours — dev1234, Oct 01 '13 at 04:11

Time or Time interval conversion with PHP

2 Answers2