14 Replies Latest reply on Nov 14, 2016 11:45 AM by philmodjunk

    Summarizing time in days and hours

    john@outdoorflooring.ca

      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,