Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I create a rolling average between 2 values?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a formula to calculate the average percentage rat | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
How do i create a "look up" to sum values in excel? | Excel Worksheet Functions | |||
Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions | |||
Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions |