hejhej.
Jag har ett problem. Jag försöker få ut antalet bokade dagar under en period baserat på månader...
X1, 2010-01-30 --> 2010-06-30 (cost=$2/h)
X2, 2010-02-10 --> 2010-12-31 (cost=$4/h)
X3, 2010-04-15 --> 2010-10-28 (cost=$2/h)
Jag vill alltså få ut bokningsinformationen på:
X1, january (2days(24h*2d*$2)),
X1, Febuary (28days(24h*28d*$2)),
X1, March (31days(24h*31d*$2)),
Och så vidare.... till Juni
X2, january (0days(0h*0d*$4)),
X2, Febuary (19days(24h*19d*$4)),
X2, March (31days(24h*31d*$4)),
X2, April (30days(24h*30d*$4)),
Och så vidare.... till April
X2, january (0days(0h*0d*$2)),
X2, Febuary (0days(0h*0d*$2)),
X2, March (0days(0h*0d*$2)),
X2, April (30days(24h*30d*$2)),
Och så vidare.... till Oktober
I want to display the no of days per month including the 'zero' days. And the booking may change, so one day it could be from April, the next day it could very well be from february.
Please help. See the snap of the workbook.
[/img]
bokningar.xls
Tacksam för hjälp.
/ Christofer
