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
LVL 1
rgb192Asked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.