Calculate sum between rows when time changes

Hi,  I have a database table which looks as follows:  id Name timestamp Value1 Value2  1 Marco 20090504 16:01:01.582 0.0000000 -0. ...