Hi,

This seems a fairly easy question but I really can't figure it out.

This is the data that I have in Crystal Report:

296,104	75	75	3	5/27/10  11:31
296,105	75	221	4	5/27/10  11:33
296,155	221	190	4	5/27/10  13:56
296,366	190	190	6	5/28/10  15:05
296,368	190	190	6	5/28/10  15:34
296,374	190	190	14	5/28/10  16:10
296,474	190	190	1	5/31/10  11:17

What I need is to calculate the time difference (elapsed time) for each row by hour. So basically, the "end time" for each calculation will be the bottom  column.

Let's say:
5/27/10  11:33  -  5/27/10  13:56 = 2 hours and 23 minutes.

The output can be any format as long as it indicates the time difference between 2 rows which will be shown in the rightmost side after the date & time

Thanks in advance for any help!