Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a field with time format 00:00:00..
Need to get average but I am getting wrong format.. any idea how to do that
Sample:
Time
00:01:17
00:00:56
00:02:02
average time is about 1.25 (One minute and twenty five seconds)..
Use interval to format the output:
=Interval( Avg( Time), 'hh:mm:ss')
or if you need to parse your Time field:
=Interval( Avg( Interval#(Time,'hh:mm:ss')), 'hh:mm:ss')
Use interval to format the output:
=Interval( Avg( Time), 'hh:mm:ss')
or if you need to parse your Time field:
=Interval( Avg( Interval#(Time,'hh:mm:ss')), 'hh:mm:ss')
thxs!
what if I want max date of a filed that the format on it is
Date
MM/DD/YYYY hh:mm:dd AM
May be this:
to get max timestamp
TimeStamp(Max(TimeStamp#(Date, 'MM/DD/YYYY hh:mm:ss TT')))
or
to get max date
Date(Floor(Max(TimeStamp#(Date, 'MM/DD/YYYY hh:mm:ss TT'))))
thank you
Did it work?
yes