SQLite Forum

Calculating Trip Duration in Minutes?
Login
The subexpression, (julianday(ended_at)-julianday(started_at)), gives a number of days. Conversion of days to minutes would require multiplication by the number of minutes a day. To a very close approximation, that is 24*60 (rather than 3600).