Im not sure if a nested IF/AND formula is the way to go or if to round it. But when I try to write the formula I get an error message. Im trying to convert time into 1/10th increments of an hour for billing and account for rounding up or down. For ex...

Has anyone else had this problem and if so how did you format it? I have duration data in Airtable, specifically time we spent on a project that we will now bill our clients for. I am attempting to use zapier to send the information into QBO so we ca...

Using airtable to track the time we spend on projects for billing purposes. I am working on gathering data sets to review whether certain types of project are profitable. I have a field for duration (using the time tracking block and h:mm:ss format) ...