Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Get Tracking Time of Day

Topic Labels: Formulas
519 2
Showing results for 
Search instead for 
Did you mean: 


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


2 Replies 2

Hi @Iman_Koma,

Welcome to Airtable Community ! :grinning_face_with_big_eyes:

You already have it in the Sum c7681515fde52c039bd5facb2372fe50a95cbe47

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


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