I am trying to put a formula in Airtable that would calculate the difference between two times and give me the result in quarter hour increments. I would import the data as follows from a spreadsheet:
Name Start Date End Date Start Time End Time Calculated Difference between two
Doe, John 3/1/2019 3/2/2019 8:45 pm 7:00 am 10.25 Hours
Smith, Jane 3/1/2019 3/2/2018 8:35 pm 7:00 am 10.25 Hours (Rounded to 8:45 pm)
What would the formula be for the calculated duration because my payroll company is set up the enter into quarter of hour increments.
Your help is greatly appreciated.