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 entere...
Not always a flat rate, just if its under an hour minimum is $85.
I am still using the actual time field to see it, have a separate field to see the amount, just thought it would be nice to calculate the minimum in the amount fieldif its less than a...
Curious if you ever thought about rounding the amount up if you have a minimum hourly service call charge?
For example if you charge $85 and the duration is 47 minutes, round up to $85 for billing?
Nathalie_Collins:
DATETIME_DIFF({End Time},{Start Time},‘seconds’)
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 ...
