First A big thanks to Richard Hipp for the answer my original trip duration post. One small clarification, If I want to calculate trip duration in minutes would I use something like this: CREATE TABLE detail AS SELECT start_lat,start_lng, rideable_type, member_casual, started_at,ended_at, (julianday(ended_at)-julianday(started_at))*3600 as duration FROM t1 WHERE duration >0 TX, David