Hi Rick

C1 - is the start cell im looking from - If this can be incorporated into the formula that would be fantastic

The reason i had C1 not copied down because i did not know how to show the formulas i was coming up with so that you guys can see what i was trying to do

If hours are added to column A - I would need to show the day count and any proportion of that day added on to the day count

So without any formulas - this is how id like the results to show based on the data in Column A

Raw Data

300 |

50 |

50 |

170 |

40 |

20 |

30 |

40 |

50 |

60 |

70 |

80 |

90 |

10 |

10 |

20 |

50 |

<tbody>

</tbody>

End Result

250 | 1 full day because it is greater than or equal to 1 | 1 |

200 | 1 full day because it is greater than or equal to 1 | 1 |

30 | 1 full day because it is greater than or equal to 1 | 1 |

0.75 | I divided at this point therefore result shows that im calculating a proportion of that day | 0.75 |

| | 3.75 |

<tbody>

</tbody>

I'm so so sorry if i'm not being clear (I'm trying)

The goal is to keep taking away the result of the formula from the next schedule until it turns out that the result is > than the next schedule therefore it needs to be divided (at that point i dont need to look at any schedules or compare going forward)

The calculation when divided needs to be added on to the count of full days

start - next (if it is start of the cell or the result of the previous calculation is > than the next scheduled hours then divide the next schedule hours else take away the next scheduled hours

If i have already divided then add this to the count of how many full days from previous calculation (ie whole numbers)