Allocate hours equally based on the given date range

UrbanNomad

Hi,

I want to allocate hours equally in weeks on the number of days in a given date range, I have attached the spreadsheet and also Image of what I'm trying to achieve, any help is greatly appreciated.

Book2.xlsx

UrbanNomad

Is it too complex to achieve?

Sean Morgan

Hello @UrbanNomad

This should be achievable using formulas.

For instance, the formula may look something like =IF(AND(Start = "6-7", End = "7-27"), "5"). Although this formula won't work without modifications, its an example of what could be achieved for the date ranges of 6-7 and 7-27. In theory, this would place the number 5 in any cell where the formula was place.

If possible, can you please provide more information on the hours vs date range? So for every cell on the date range of 6-7 and 7-27, should all the cells in that range contain 5?

Additionally, you may want to contact our consulting team to have a custom solution built for your business requirements. See more on this process here: https://www.smartsheet.com/services/consulting

Regards

Sean

Genevieve P.

Hi @UrbanNomad

If Sean's suggestion above hasn't helped, you may also want to review this Community Post that had a similar question: https://community.smartsheet.com/discussion/comment/247491#Comment_247491

UrbanNomad

@Genevieve P @Sean Morgan : I don't think this requires a customized formula, I could achieve the same in excel.

@Genevieve P : Thanks for the link, it didn't help.