SQLite Forum

Calculating Trip Duration in Minutes?
Login
> (julianday(ended_at)-julianday(started_at))*3600

I do the number of minutes in a day: 1440. If it's less than a day, you'll get a decimal number.