Could anyone suggest other ways of achieving summing of times ie sum(end_time - start_time). At the moment I have a rather unwieldy sql query (see below).
sum( (strftime("%H",end_time)*60+strftime("%M",end_time)) - (strftime("%H",start_time)*60+strftime("%M",starttime)) )
sum(end_time - start_time)*1440
end_time and start_time are both in (fractional) days since the julian epoch (-4713-11-24 12:00:00 UTC). The "*1440" at the end converts from days into minutes. If you want an integer number of minutes, do this:
round(sum(end_time-start_time)*1440)
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
