[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

confusing time_difference invoice to calculate total_time

doing programming hours invoice
sometimes I know the start_time - end_time
and other times I just know the daily hours (for days where I work 1 hour, take a 2 hour break work 3 more hours, take a 5 hour break, work 1 more hour)


3 mysql columns
start_time datetime
end_time datetime
time_difference   (maybe I should use int and calculate seconds)

I am confused with time_difference (php form input textbox)
a user is entering time_difference (sometimes calculated from start_time-end_time, sometimes without start_time_endtime) in an input textbox which gets saved into mysql and then displayed in the input textbox again

hours minutes in this format:
h:i

6:05


want to convert
to seconds mysql format int (because it is difficult to say that I worked 1800439 seconds in one day)

and then back into
h:i

how to do the two conversions


note that the total_time is the sum of all the time_difference


is there a better way to do this
0
rgb192
Asked:
rgb192
1 Solution
 
mickey159Commented:
function time_to_str($str){
$c=explode(":",$str);
$int=$c[0]*3600+$c[1]*60;
return $int;
}

function str_to_time($int){
$hrs=floor($int/3600);
$mins=($int-$hrs*3600)/60;
$str=$hrs.":".($mins<10?"0".$mins:$mins);
return $str;
}

Open in new window


This should solve your problem.
I hope this helps. :-)
0
 
rgb192Author Commented:
these two functions work great in textbox and mysql

thank you
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now