Alec_East - profile

Alec_East · Aug 29, 2018

Mabye this is an easy one for you Airtable gurus. I am currently creating a more or less complex ToDo list and want to create a field which calculates the difference between Estimate and ACTUAL use of time. Does anyone know a simple trick or formula ...

Alec_East · Aug 29, 2018

The solution in calculating the difference and summing it up is the formula: ({Expected} - {Actual})/60 After adding the formula into the “Formula field” you simply have to group (by whatever value you like; Can be per month or day, or by task type...

Alec_East · Aug 29, 2018

I am using a duration fields. According to that it sums them up, what the formula field unfortunately isn’t. Is there a solution to sum up these values when collapsed in group?

Alec_East · Aug 29, 2018

@Jacob_Turley As I inserted your formula, there was a failure. Is the “hours” part being inserted as well or is this value also changed/customized according to the table?

Alec_East · Aug 29, 2018

Thank you very much. As I inserted the formula it seems that the time difference is not being viewed or summed up. Therefore, must I remove the minutes? What can i do that it detects it as a value? Many thanks in advance.

Alec_East · Aug 29, 2018

Jacob_Turley: DATETIME_DIFF({Estimated Date},{Actual Date},‘hours’) I really appreciate your presence on planet earth. Thanks :slightly_smiling_face:

User Statistics

User Activity

Calculate the difference in hours based on two time fields [SOLVED]

Re: Calculate the difference in hours based on two time fields [SOLVED]

Re: Calculate the difference in hours based on two time fields [SOLVED]

Re: Calculate the difference in hours based on two time fields [SOLVED]

Re: Calculate the difference in hours based on two time fields [SOLVED]

Re: Calculate the difference in hours based on two time fields [SOLVED]