difficult calculation

[sandy8445]

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.

[thameem127]

Cannot understand your problem. Please explain

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.