SQLite Forum

Calculating Trip Duration in Minutes?
"Julianday" is a representation/measurement in days or fractions thereof.

So there are 24 hours in a day, 1440 minutes in a day and 86400 seconds in the average day.

If you have a factor in "days" (or fractions thereof) then to translate it to hours requires you multiplying it by 24, for minutes it is * 1440 and for seconds it is * 86400.