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) |