Insert Duration from Users Form
Posted on 2009-07-01
This can't be that hard but after hours of reading and testing I've got very comfused and a little angry with my PC, I know it's not its fault really....
What I need is a way to insert the duration time from two input text boxes named/ID'ed TripStart and TripEnd, when the form is posted all I need is a calculation of time passed from TripStart and TripEnd.
i.e. user enters 10:30 and 12:30, I need both those added to database (can do this ok), but also in another field called Duration the results of the calculation, 2:00. should the time be entered 23:30 and 03:30 the value added should be 4:00.
Any help would be good, pretty good at the database side of things, its the PHP that is killing me, lol...
High points as need a fast and clear to follow method, willing to increase points if needed.