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.
Makes perfect sense, exactly what i was looking for!! Thanks!! This also helped me get a grasp on the function. Thanks again, i just started looking at air table last night to use for my business. Everything off the shelf is way more than what i need.
Sounds like you’re referring to having a flat rate. Do you always perform flat rates or is it a mixture?
I do a bit of both. So my setup has been created to allow for markups, discounts and flat rates. This allows me to keep track of physical performance rather than focusing ONLY on the billing amount.