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,