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,

Hi,

you might consider using a Timestamp field, or at least the function GetAsTimestamp(Date; Time). This can be evaluated in terms of seconds between the two events.