AnsweredAssumed Answered

Summarizing time in days and hours

Question asked by on Nov 13, 2016
Latest reply on Nov 14, 2016 by philmodjunk

Hi there. I am trying to summarize the hours we have been sailing by year and month. A single trip can easily cross over a 24 hour period as we do a lot of night sailing and trips of over 12 hours. so the "trip dur" field is a calculation.


((Travel Log::Date_arrived - Travel Log::Departure Date)  *86400) + (Arrival time-Time_of_ Departure) this calculation field is a text field.


The scenario is:

We leave from La Paz. On february 12th at 9:00am in the morning and we arrive in Banderas Bay February 15th at 15:00. The trip duration is therefore is 78 hours or 3 days and 6 hours.


Now I want to summarize the result of this calculation. I cannot figure it out for the life of me


Thanks for your help,