Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Daily summary from RescueTiime

819 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeongyong_Kim
5 - Automation Enthusiast
5 - Automation Enthusiast

I set up IFTTT algorithm so that daily summary from RescueTime should be saved to AirTable.

It records my daily total time, productive time, and distracting time as a separate column (‘duration’ field with ‘h:mm’ format in airtable) and one row per day.
My yesterday’s total time, productive time, and distracting time were 8 h 6 m, 3 h 4 m, and 2 h 44 m,
but the AirTable record for yesterday is weird.
They are respectively recorded as 1:26 (1h 26m = 86m which may be mis-understood from 8h 6m),
0:34 ( 34 m. mistaken from 3h 4m), 4:04 (4 h 4m = 244m mistaken from 2h 44m)

How can I correct this?

(RescueTime also sends daily summary to Telegram and MS OneNote and they show the duration correctly. So I believe it is not a problem caused by RescueTime or IFTTT.)

2 Replies 2
Jeongyong_Kim
5 - Automation Enthusiast
5 - Automation Enthusiast

Does anybody have solution for this?

Duration fields are stored as minutes in Airtable, so you should send the data to Airtable as minutes instead of hours.