php - Converting MysQl Time to decimal format -


i'm trying convert time format 00:00:00 decimal 0.00.

i tried this:

<?php     $hourswork_wk1 = $deposit26['hours_worked'];    $decimalhourswk1 = decimalhours($hourswork_wk1);    decimalhours();      function decimalhours($timewk1)     {         $hourswork_wk1 = explode(":", $timewk1);         return ($hourswork_wk1[0] + ($hourswork_wk1[1]/60) + ($hourswork_wk1[2]/3600));         echo $decimalhours     }   ;?>

edit

<?php     $hourswork_wk1 = $deposit26['hours_worked'];    $decimalhourswk1 = decimalhours($hourswork_wk1);      function decimalhours($timewk1)     {         $hourswork_wk1 = explode(":", $timewk1);         return ($hourswork_wk1[0] + ($hourswork_wk1[1]/60) + ($hourswork_wk1[2]/3600));      } ?>

i call undefined function decimalhours() error. doing wrong?

alright reason code have written never worked me. after looking around more tangible stumbled upon philip norton code works charm dynamic variables. suit yourself.

script

<?php //$week1hours = $deposit26['hours_worked']; $week1hours = "14:33:38"; function time_to_decimal($time) {     $timearr = explode(':', $time);     $dectime = ($timearr[0] + ($timearr[1]/60) + ($timearr[2]/3600));     return $dectime; } echo time_to_decimal($week1hours); ?>

result

14.560555555556

bonus : limit 2 decimals

use round 2 decimals

<?php //$week1hours = $deposit26['hours_worked']; $week1hours = "14:33:38"; function time_to_decimal($time) {     $timearr = explode(':', $time);     $dectime = ($timearr[0] + ($timearr[1]/60) + ($timearr[2]/3600));     return $dectime; } $totalhours= time_to_decimal($week1hours); echo round($totalhours, 2); ?>

result

14.56

Comments

Post a Comment

Popular posts from this blog

javascript - Confirm a form & display message if form is valid with JQuery -

i'm developing django application , use javascript in order improve website. i have form , display 2 things : confirm form before submit if form submitted, display message : 'form saved' it's first time i'm using js , need make process. this code : <form class = "form" method='post' action=''> {% csrf_token %} <br></br> {{ form.as_p}} <br></br> <button type="submit">valider</button> </form> <script> $('#form').submit(function() { var c = confirm("click ok continue?"); return c; //you can return c because true or false }); </script> and if form valid , saved : <script type="text/javascript" > $(document).on('valider', 'form.form', function(form) { var $form = $(form); $.ajax({ ...
Read more

Retrieving ETA (estimated time of arrival) with Google Distance Matrix API and public transit as transport mode -

Image
is possible retrieve eta google's distancematrix api (or alternative api). fyi, eta different duration, when using public transport. following example clarify request. when leave on friday @ 8.15 i'll able catch train @ 8.30 , arrive @ 9.00 am. google says duration 30 minutes. however, when leave on saturday @ 8.15 i'll able catch first train @ 9.00 , arrive @ 9.30 am. google still says duration 30 minutes, means ignore delay. google map supports functionality there api around giving me eta instead of duration. can see, distance-matrix' response no good. clarifying question little. eta estimated time of arrival , it's clear user wants know entire duration of transport (including waiting time public transport).
Read more

ionic framework - Meteor - Error: Failed to execute 'insertBefore' on 'Node' -

i trying make dynamic list display using meteor, idea load more elements each time bottom of page reached. the html template following : <template name="contacts"> {{#contentfor "headertitle"}} <div class="bar bar-header bar-assertive"> <h1 class="title">contacts :</h1> </div> {{/contentfor}} {{#ionview}} {{#ioncontent}} <div class="list"> {{#each contacts}} <a class="item item-avatar" href="/contacts/{{_id}}"> <img src="/img/ico_client.png"> <h2>{{full_name}}</h2> <p>{{company}}</p> </a> {{/each}} </div> {{#if moreresults}} <div id="showmoreresults" style="margin-left: 25px;"> <span class="loading">loading...</span> </div> {{/if}} {{/ioncontent}} {{/ionview}} </te...
Read more