Have this formula for calculating time =TEXT(E9-D9, "h") but when new information is enter on another row the formula does not copy down nor if I insert a row between the data the formula does not copy. Any suggestions.
| Comp Time Sheet.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 3 | 15-Sep-21 | Holiday Event | 12:00 PM | 5:00 PM | 5 | 5 | ||||
| 4 | Event | 1:00 PM | 5:00 PM | 4 | 9.00 | |||||
| 5 | Event | 2:00 PM | 5:00 PM | 3 | 12.00 | |||||
| 6 | Event | 2:00 PM | 5:00 PM | 3 | 15.00 | |||||
| 7 | Event | 1:00 PM | 3:00 PM | 2 | 17.00 | |||||
| 8 | Event | 5:00 PM | 8:00 PM | 3 | 20.00 | |||||
| 9 | Event | 4:00 PM | 6:00 PM | 2 | 22.00 | |||||
| 10 | Event | 10:00 AM | 1:00 PM | 3 | 25.00 | |||||
| 11 | Event | 11:00 AM | 2:00 PM | 3 | 28.00 | |||||
| 12 | Event | 10:00 AM | 2:00 PM | 4 | 32.00 | |||||
| 13 | Event | 10:00 AM | 2:00 PM | 4 | 36.00 | |||||
| 14 | Event | 10:00 AM | 2:00 PM | 4 | 40.00 | |||||
| 15 | Event | 10:00 AM | 3:00 PM | 5 | 45.00 | |||||
| 16 | Event | 10:00 AM | 4:00 PM | 6 | 51.00 | |||||
| 17 | Event | 11:00 AM | 5:00 PM | 6 | 57.00 | |||||
| 18 | Event | 10:00 AM | 5:00 PM | 7 | 64.00 | |||||
| 19 | Event | 11:00 AM | 5:00 PM | 6 | 70.00 | |||||
| 20 | Event | 10:00 AM | 5:00 PM | 7 | 77.00 | |||||
| 21 | Event | 11:00 AM | 5:00 PM | 6 | 83.00 | |||||
| 22 | Event | 10:00 AM | 5:00 PM | 7 | 90.00 | |||||
| 23 | Event | 11:00 AM | 5:00 PM | 6 | 96.00 | |||||
| 24 | Event | 10:00 AM | 4:00 PM | 6 | 102.00 | |||||
| 25 | Event | 11:00 AM | 5:00 PM | 6 | 108.00 | |||||
Sheet1 | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F3:F25 | F3 | =TEXT(E3-D3, "h") |
| H3 | H3 | =(F3) |
| H4:H25 | H4 | =(H3+F4-G4) |
