duplicate (one time or multiple times) row (with CONCATENATE)

[#1]

Hello Users,

I have the following questions

I want to load the following data set
Date Time Duration[in h]
1/1/2010 7:00PM 10

In the attached file, the result is
Date FromTime ToTime Duration[in h]
1/1/2010 7:00PM 11.59PM 5
1/2/2010 12:00AM 5:00AM 5

But I don't have an idea to get to this
Date Time Duration[in h]
1/1/2010 7:00PM 50

In the attached file, the result is
Date FromTime ToTime Duration[in h]
1/1/2010 7:00PM 11.59PM 5
1/2/2010 12:00AM 11.59PM 24
1/3/2010 12:00AM 9.59PM 21

I can't get it to work, can somebody help me out with this?

Thanks in advance,

Oliver

[sathishkumar_go]

Hi Oliver,

In attached file Date is 4/8/2010 and todate also 4/8/2010

what do u want? do u want to calculate 1/1/2010 to 4/8/2010?

-Sathish

[#3]

Hi Sathish,

sorry, I used a different file I played with. Attached the right one including the XLS file. You will see, that one row is missing. I have no idea how to implement that.

Thanks for your help,

Oliver

[pover]

Oliver,

Here's a solution using intervalmatch and a straight table. It might need a little refining, but it gives you the table you are looking for.

Regards.

[#5]

Karl,

thanks for your idea. But it doesn't work, I need the data in the datafile, without modifications in the chart/interface area.

I need to add basically rows.

Any ideas?

Thanks, Oliver