Skip to main content

Hello,


We have 2 Row From and To and its datetime !


How may i find the diffrent time from ( from ) until To in the Same day ? please check the image


Hi @Iman_Koma,


Welcome to Airtable Community ! :grinning_face_with_big_eyes:


You already have it in the Sum


If you want this number to show in a record, you have 2 options:




  1. Link these records by day in another field, rollup the Min and Max times, then get the difference.




  2. Use the script block




BR,

Mo

Hi @Iman_Koma,


Welcome to Airtable Community ! :grinning_face_with_big_eyes:


You already have it in the Sum


If you want this number to show in a record, you have 2 options:




  1. Link these records by day in another field, rollup the Min and Max times, then get the difference.




  2. Use the script block




BR,

Mo


mhmm i have a sum but its not exactly because we can set two record with the same time .

Reply


Terms & Conditions