AnsweredAssumed Answered

Summarizing time in days and hours

Question asked by john@outdoorflooring.ca 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,

Outcomes