excel cell merge

[#1]

Hi,

I have an excel table that looks like this (or see attached file for )

id	statut	date_start	date_end	duree
id1	demande ouverte	01/05/2010 10:02		-
id1	demande ouverte		02/06/2010 11:13	-
id2	qualif	02/05/2010		-
id2	qualif		03/05/2010 12:25	-

and I want to merge cells to obtain duree (duree= date_end-date_start)

Yours faithfully

Regards

[martin59]

Hi,

You can try with :

interval(date_start-date_end)