Link to home
Start Free TrialLog in
Avatar of rgb192
rgb192Flag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of mickey159
mickey159
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rgb192

ASKER

these two functions work great in textbox and mysql

thank you