average of time field

[alec1982]

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)..

[swuehl · Accepted solution]

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')

[alec1982]

thxs!

[alec1982]

what if I want max date of a filed that the format on it is

Date

MM/DD/YYYY hh:mm:dd AM

[sunny_talwar]

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'))))

[alec1982]

thank you

[sunny_talwar]

Did it work?

[alec1982]

yes