avg time from timestamp

[#1]

Hello,

im new in QlikView and I have a Question regarding the avg time from timestamps.

my field is a timestamp and the target is to calculate the average time - date is not important for me.

Result must be 04:11:00.

How can I do that?

Thanks for your help.

original field Format (Expression Default):

number Format seeting: timestamp

[sunny_talwar]

So are you trying to fix the Total row?

[#3]

mmhh sorry, what do you mean exactly? I think the solution must be anything like deleting date and having the time only...?

[sunny_talwar · Accepted solution]

To remove the date, you can use Frac

Avg(Frac([Fahrt  Beginn]))

[#5]

Thanks, thats working!

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

[#7]

Done, thanks for your Help 🙂