hi,
i have applied formula D5=B2+C5=01:00, but i want next day when i change date(A2) and hours (B2), new hours become previous hours & again new hours with fresh entries. suppose next day on 24/01/2014 if i change value in B2 is 2:00 hrs , then previous hrs should be 01:00 & new hrs should be 03:00. and summary of all values inserted (since last time) in A2 & B2 on next sheet.
A B C D E
1 date hours
2 23/01/2013 00:30
3
4 Name Previous hrs New hrs
5 Component A 00:30 01:00
6 Component B 00:45 01:15
7 Component C 10:00 10:30
8 Component D 10:45 11:15
9 Component E 120:15 120:45
10 Component F 100:45 101:15
11 Component G 200:55 201:25
is any one here to solve this ?
need help.
Bookmarks