Convert seconds to Hour Minute Second

Question

I need to convert seconds to  Hour Minute Second    For example   685  converted to  00 11 25   How can I achieve this

User · Answer

given   685          In case  given    86400  gmdate   H    will convert it into  00  i e  midnight     We would need to take this into consideration  and so we will first    check the ratio of the seconds i e   given  number of sec in a day    and then after multiplying it by the number of hours in a day  24   we    will just use  floor  to get the number of hours as the rest would    be the minutes and seconds anyways        We can also have minutes and seconds combined in one variable     e g   min sec   gmdate   i s    given       But for versatility sake  I have taken them separately        hours      given  gt  86399      0  floor     given   86400     24  -gmdate   H    given     gmdate  H    given      min   gmdate   i    given      sec   gmdate   s    given     echo  formatted string    hours      min      sec    To convert it into a function   function getHoursFormat   given       hours      given  gt  86399      0  floor     given   86400     24  -gmdate   H    given     gmdate  H    given       min   gmdate   i    given       sec   gmdate   s    given       formatted string    hours      min      sec    return  formatted string

User · Answer

Use function gmdate   only if seconds are less than 86400  1 day      seconds   8525  echo gmdate  H i s    seconds     02 22 05   See  gmdate    Run the Demo    Convert seconds to format by  foot  no limit      seconds   8525   H   floor  seconds   3600    i     seconds   60    60   s    seconds   60  echo sprintf   02d  02d  02d    H   i   s     02 22 05   See  floor    sprintf    arithmetic operators  Run the Demo    Example use of DateTime extension    seconds   8525   zero      new DateTime   0     offset    new DateTime    seconds     diff       zero- gt diff  offset   echo sprintf   02d  02d  02d    diff- gt days   24    diff- gt h   diff- gt i   diff- gt s     02 22 05   See  DateTime    construct    DateTime  modify    clone   sprintf    Run the Demo    MySQL example range of the result is constrained to that of the TIME data type  which is from -838 59 59 to 838 59 59    SELECT SEC TO TIME 8525     02 22 05   See  SEC TO TIME  Run the Demo    PostgreSQL example   SELECT TO CHAR  8525 second   interval   HH24 MI SS      02 22 05   Run the Demo

User · Answer

Solution from  https   gist github com SteveJobzniak c91a8e2426bac5cb9b0cbc1bdbc45e4b  Here is a very clean and short method   This code avoids as much as possible of the tedious function calls and piece-by-piece string-building  and the big and bulky functions people are making for this   It produces  1h05m00s  format and uses leading zeroes for minutes and seconds  as long as another non-zero time component precedes them   And it skips all empty leading components to avoid giving you useless info like  0h00m01s   instead that will show up as  1s     Example results   1s    1m00s    19m08s    1h00m00s    4h08m39s     duration   1     values 0 and higher are supported   converted          hours    gt  floor   duration   3600         minutes    gt  floor     duration   60     60         seconds    gt     duration   60       result   ltrim  sprintf    02dh 02dm 02ds    converted  hours     converted  minutes     converted  seconds       0hm     if   result     s       result    0s       If you want to make the code even shorter  but less readable   you can avoid the  converted array and instead put the values directly in the sprintf   call  as follows    duration   1     values 0 and higher are supported   result   ltrim  sprintf    02dh 02dm 02ds   floor   duration   3600    floor     duration   60     60       duration   60       0hm     if   result     s       result    0s       Duration must be 0 or higher in both of the code pieces above  Negative durations are not supported  But you can handle negative durations by using the following alternative code instead    duration   -493     negative values are supported   wasNegative   FALSE  if   duration  lt  0      wasNegative   TRUE   duration   abs   duration       converted          hours    gt  floor   duration   3600         minutes    gt  floor     duration   60     60         seconds    gt     duration   60       result   ltrim  sprintf    02dh 02dm 02ds    converted  hours     converted  minutes     converted  seconds       0hm     if   result     s       result    0s     if   wasNegative      result    -  result          result is now  -8m13s

User · Answer

The following codes can display total hours plus minutes and seconds accurately  duration in seconds   86401  if  duration in seconds gt 0        echo floor  duration in seconds 3600  gmdate  quot  i s quot    duration in seconds 3600     else       echo  quot 00 00 00 quot

User · Answer

gmdate  H i s   no of seconds     Will not give time in H i s format if no of seconds is greater than 1 day  seconds in a day   It will neglect day value and give only Hour Min Seconds  For example   gmdate  H i s   89922      returns 0 58 42 not  1 Day 0 58 42  or 24 58 42

User · Answer

The gmtdate   function didn t work for me as I was tracking hours worked on a project and if it s over 24 hours  you get amount left over after 24 hours is subtracted  In other words 37 hours becomes 13 hours   all as stated above by Glavic - thanks for your examples   This one worked well   Convert seconds to format by  foot  no limit    seconds   8525   H   floor  seconds   3600    i     seconds   60    60   s    seconds   60  echo sprintf   02d  02d  02d    H   i   s     02 22 05

User · Answer

Anyone whose looking for this in the future  this gives the format the initial poster asked for    init   685   hours   floor  init   3600    hrlength strlen  hours   if   hrlength  1    hrs  0   hours   else   hrs  hours      minutes   floor   init   60    60    minlength strlen  minutes   if   minlength  1    mins  0   minutes   else   mins  minutes      seconds    init   60   seclength strlen  seconds   if   seclength  1    secs  0   seconds   else   secs  seconds     echo   hrs  mins  secs

User · Answer

If you don t like accepted answer or popular ones  then try this one  function secondsToTime  seconds time        if   seconds time  lt  24   60   60            return gmdate  H i s    seconds time         else            hours   floor  seconds time   3600            minutes   floor   seconds time -  hours   3600    60            seconds   floor  seconds time -   hours   3600  -   minutes   60            return   hours  minutes  seconds            secondsToTime 108620      30 10 20

User · Answer

Other solutions use gmdate  but fail in edge cases where you have more than 86400 seconds  To get around this  we can simply compute the number of hours ourselves  then let gmdate compute the remaining seconds into minutes seconds   echo floor  seconds   3600    gmdate   i s    seconds   3600     Input  6030 Output  1 40 30  Input  2000006030 Output  555557 13 50

User · Answer

function timeToSecond  time        time parts explode      time        seconds    time parts 0  86400      time parts 1  3600      time parts 2  60     time parts 3         return  seconds     function secondToTime  time        seconds     time   60       seconds lt 10    0   seconds    seconds      if  seconds lt 10             seconds  0   seconds             time         time -  seconds    60       minutes     time   60      if  minutes lt 10             minutes  0   minutes             time         time -  minutes    60       hours       time   24      if  hours lt 10             hours  0   hours             days         time -  hours    24      if  days lt 10             days  0   days              time arr   array  days  hours  minutes  seconds       return implode      time arr

User · Answer

lt  php  time 3 3600   30 60     year floor  time  365 24 60 60     time-  year  365 24 60 60     month floor  time  30 24 60 60     time-  month  30 24 60 60     day floor  time  24 60 60     time-  day  24 60 60     hour floor  time  60 60     time-  hour  60 60     minute floor  time  60     time-  minute  60     second floor  time    time-  second  if  year gt 0       echo  year   year       if  month gt 0       echo  month   month       if  day gt 0       echo  day   day       if  hour gt 0       echo  hour   hour       if  minute gt 0       echo  minute   minute       if  second gt 0       echo  second   second

User · Answer

This function my be useful  you could extend it   function formatSeconds  seconds     if  is integer  seconds         return FALSE      fmt         days   floor  seconds   86400   if  days         fmt     days  D         seconds    86400      hours   floor  seconds   3600   if  hours         fmt    str pad  hours  2   0   STR PAD LEFT            seconds    3600      mins   floor  seconds   60    if  mins         fmt    str pad  mins  2   0   STR PAD LEFT            seconds    60      fmt    str pad  seconds  2   0   STR PAD LEFT    return  fmt

User · Answer

A simple way to use DateTime for this is        time   60    sec       now   time         rep   new DateTime      now        diff   new DateTime       now  time         return    diff- gt diff  rep - gt format  format          output   01 04 65   It s a simple solution wich gives you the ability to use the format Method of DateTime

User · Answer

One hour is 3600sec  one minute is 60sec so why not    lt  php   init   685   hours   floor  init   3600    minutes   floor   init   60    60    seconds    init   60   echo   hours  minutes  seconds      gt    which produces     php file php 0 11 25    I ve not tested this much  so there might be errors with floor or so

User · Answer

If you need to do that in javascript  you can do it in just one line of code as answered here Convert seconds to HH-MM-SS with JavaScript  Replace SECONDS with what you want to convert   var time   new Date SECONDS   1000  toISOString   substr 11  8

User · Answer

Just in case anyone else is looking for a simple function to return this nicely formatted  I know it is not the format the OP asked for   this is what I ve just come up with  Thanks to  mughal for the code this was based on   function format timer result  time in seconds        time in seconds   ceil  time in seconds           Check for 0     if   time in seconds    0           return  Less than a second                 Days      days   floor  time in seconds    60   60   24         time in seconds -   days    60   60   24           Hours      hours   floor  time in seconds    60   60         time in seconds -   hours    60   60           Minutes      minutes   floor  time in seconds   60        time in seconds -   minutes   60          Seconds      seconds   floor  time in seconds           Format for return      return           if   days  gt  0            return     days     day      days    1         s                   if   hours  gt  0            return     hours     hour      hours    1         s                    if   minutes  gt  0            return     minutes     minute      minutes    1         s                    if   seconds  gt  0            return     seconds     second      seconds    1         s                     return   trim  return        return  return

User · Answer

In java you can use this way      private String getHmaa long seconds        String string      int hours    int  seconds   3600      int remainder    int  seconds - hours   3600      int mins   remainder   60        remainder   remainder - mins   60        int secs   remainder       if  hours  lt  12  amp  amp  hours  gt  0            if  mins  lt  10                string   String valueOf  hours  lt  10    0    hours   hours           mins  gt  0    0    mins    0       AM              else               string   String valueOf  hours  lt  10    0    hours   hours           mins  gt  0   mins    0       AM                    else if  hours  gt   12            if  mins  lt  10                string   String valueOf   hours - 12   lt  10    0     hours - 12      hours - 12     12    0     hours - 12             mins  gt  0    0    mins    0       hours - 12     12     AM      PM               else               string   String valueOf   hours - 12   lt  10    0     hours - 12      hours - 12     12    0     hours - 12             mins  gt  0   mins    0       hours - 12     12     AM      PM                     else           if  mins  lt  10                string   String valueOf  0           mins  gt  0    0    mins    0       AM              else               string   String valueOf  0           mins  gt  0   mins    0       AM                        return string

User · Answer

You can use the gmdate   function   echo gmdate  H i s   685

User · Answer

If you want to create a audio video duration string like YouTube  etc  you can do     seconds  gt   60    ltrim gmdate  H i s    seconds     0     gmdate  0 s    seconds   Will return strings like   55 55   gt   0 55  100     gt   1 40    Probably won t work well for time    24 hours

User · Answer

Here is a one liner that handles negative seconds and more than 1 day worth of seconds   sprintf   s   02s   02s n   intval  seconds 60 60   abs intval   seconds 3600    60    abs  seconds 60      For Example    seconds  -24 60 60 - 2 60 60 - 3 60 - 4     minus 1 day 2 hours 3 minutes 4 seconds echo sprintf   s   02s   02s n   intval  seconds 60 60   abs intval   seconds 3600    60    abs  seconds 60      outputs  -26 03 04

User · Answer

TEST    1 Day 6 Hours 50 Minutes 31 Seconds   111031 seconds   time   111031     time duration in seconds   days   floor  time    60   60   24     time -   days    60   60   24     hours   floor  time    60   60     time -   hours    60   60     minutes   floor  time   60    time -   minutes   60    seconds   floor  time    time -   seconds   echo    days d   hours h   minutes m   seconds s      1d 6h 50m 31s

User · Answer

This is a pretty way to do that   function time converter  sec time   format  h m s           hour   intval  sec time   3600   gt   10   intval  sec time   3600     0  intval  sec time   3600          minute   intval   sec time   3600    60   gt   10   intval   sec time   3600    60     0  intval   sec time   3600    60          sec   intval   sec time   3600    60    gt   10   intval   sec time   3600    60     0  intval   sec time   3600    60           format   str replace  h    hour   format          format   str replace  m    minute   format          format   str replace  s    sec   format          return  format

User · Answer

Well I needed something that would reduce seconds into hours minutes and seconds  but would exceed 24 hours  and not reduce further down into days   Here is a simple function that works  You can probably improve it    But here it is   function formatSeconds  seconds         hours   0  minutes   0      while  seconds  gt   60   seconds -  60  minutes         while  minutes  gt   60   minutes - 60  hours          hours   str pad  hours  2   0   STR PAD LEFT        minutes   str pad  minutes  2   0   STR PAD LEFT        seconds   str pad  seconds  2   0   STR PAD LEFT       return  hours      minutes      seconds

User · Answer

Try this   date  H i s  -57600   685     Taken from http   bytes com topic php answers 3917-seconds-converted-hh-mm-ss

User · Answer

write function like this to return an array  function secondsToTime  seconds          extract hours    hours   floor  seconds    60   60          extract minutes    divisor for minutes    seconds    60   60      minutes   floor  divisor for minutes   60         extract the remaining seconds    divisor for seconds    divisor for minutes   60     seconds   ceil  divisor for seconds         return the final array    obj   array         h    gt   int   hours         m    gt   int   minutes         s    gt   int   seconds           return  obj      then simply call the function like this   secondsToTime 100     output is  Array    h    gt  0  m    gt  1  s    gt  40

User · Answer

See                   Convert number of seconds into hours  minutes and seconds         and return an array containing those values                  param integer  inputSeconds Number of seconds to parse          return array                function secondsToTime  inputSeconds              secondsInAMinute   60           secondsInAnHour    60    secondsInAMinute           secondsInADay      24    secondsInAnHour              extract days          days   floor  inputSeconds    secondsInADay               extract hours          hourSeconds    inputSeconds    secondsInADay           hours   floor  hourSeconds    secondsInAnHour               extract minutes          minuteSeconds    hourSeconds    secondsInAnHour           minutes   floor  minuteSeconds    secondsInAMinute               extract the remaining seconds          remainingSeconds    minuteSeconds    secondsInAMinute           seconds   ceil  remainingSeconds               return the final array          obj   array               d    gt   int   days               h    gt   int   hours               m    gt   int   minutes               s    gt   int   seconds                     return  obj          From  Convert seconds into days  hours  minutes and seconds

User · Answer

here you go  function format time  t  f         t   seconds  f   separator      return sprintf   02d s 02d s 02d   floor  t 3600    f    t 60  60   f   t 60      echo format time 685      00 11 25

[php] Convert seconds to Hour:Minute:Second

Examples related to php

Examples related to time