I have a database that I track service calls with.
i have a start time, end time, and a field called invoice time.
I would like the invoice time to calculate the hours i am going to invoice the customer for based on the start time and end time entered for the service call.
start time 8:00am End Time 9:00am = invoice time 60 minutes or 1 hour.
start time 8:00am End Time 8:45am = invoice time 45 minutes.
It would be nice if i could pick a time on the start and end colums with a picker, right now i have to manually enter the times.