Calculate Time from 2nd Start Time

[rustyfishbones]

Hi All,

I have a list of values and I want to calculate the time from the 2nd Start Time and the End Time.

So in the below instance it will be from 8:00:12 that I need to calculate the time from

[rustyfishbones]

Just to Clarify

The result I require is the next value after the MIN([Start Time])

Regards

Alan

[#3 · Accepted solution]

Try the FirstSortedValue function

You have a last argument that returns the nth value you want.

Sth like FirstSortedValue(StartTime, StartTime, 2)

Fabrice

[rustyfishbones]

Excellent I did realize you could add the 2 to get the second value

thanks so much!

learning lots today

[#5]

I learnt it 5 days ago !!