Hi,

I have an excel spreadsheet and need to create average times in between a
start time and finish time within a single column. For instance, if A1
contains 10:00 & A10 contains 12:00 cells A2:A9 should contain a rolling
average between them so A2=10:12, A3=10:24 and so on to create a staggered
set of times. The number of cells in between the start and end times has to
be variable and it ideally needs to be able to deal with situations where the
start & finish times go accross midnight. The times need to be formatted
American style with hours & minutes (10am as 10:00).

Many thanks