Seperate timestamp use in pivot

[#1]

I have a table that is a timestamp.

Each day there are diferrent times.

Fe:

31/12/2013 4:30:45

31/12/2013 5:38:47

31/12/2013 5:30:00

01/01/2014 4:25:15

01/01/2014 4:12:23

I want to show in a pivot table all the different dates an when you click further al the times for that day.

Something like this:

31/12/2013     4:30:45

                     5:38:47

                     5:30:00

01/01/2014     4:25:15

                     4:12:23

I added a qvw with sample data.

[ashfaq_haseeb · Accepted solution]

Have a look at the attached document

Regards

ASHFAQ

[#3]

That worked, I forgot to fill in an expression.

Thanks!

[ashfaq_haseeb]

Glad That it worked.

Regards

ASHFAQ

[#5]

Do you happen to know how to calculate the timedifference between each time?

[ashfaq_haseeb]

use above function

RegardsASHFAQ

[#7]

this calculates the interval that I need:

=below(emptyings_time,1)-(emptyings_time)

How do I get this in a time format?

Because I want to display this in a chart.

[ashfaq_haseeb]

May be like this

Interval(MakeTime(Floor(below(emptyings_time,1)-(emptyings_time)), Round(Frac(below(emptyings_time,1)-(emptyings_time))*60)))

Regards

ASHFAQ

[#9]

Doesn't work unfortunatly.

[ashfaq_haseeb]

Hi,

Have a look at the attached document.

You can hide column(1)

Regards

ASHFAQ