Hello there,
I am trying to allocate revenue for a period of time into months.
I have 2 options.
The first one is Start Day: Time - End Day : Time and then allocate the days & revenue in each month. I have used the formulas EOMONTH, MAX but when I add the days for each month am missing one day. I have also try to add 1 day, but the revenue per day is not correct finally.
For ex. Start : 01 Jan 2016 20:00 End: 09 Feb 2016 23:30 = 40 Days & 3:30 hours.
The Second one is Start Day: Time and then give the project duration.
For Ex. Start: 01 Jan 2016 20:00 Duration : 40 Days & 3:30 hours
I Attach the relevant file.
Thank you in advance
I am trying to allocate revenue for a period of time into months.
I have 2 options.
The first one is Start Day: Time - End Day : Time and then allocate the days & revenue in each month. I have used the formulas EOMONTH, MAX but when I add the days for each month am missing one day. I have also try to add 1 day, but the revenue per day is not correct finally.
For ex. Start : 01 Jan 2016 20:00 End: 09 Feb 2016 23:30 = 40 Days & 3:30 hours.
The Second one is Start Day: Time and then give the project duration.
For Ex. Start: 01 Jan 2016 20:00 Duration : 40 Days & 3:30 hours
I Attach the relevant file.
Thank you in advance