Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
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