Hi All,
I have an issue where you have to calculate the Start time and End Time , Start Date and End Date for a particular Work item number
For eg ;
WI_ID WI_CD WI_CT
000001312610 02/09/2009 09:48:4 02/09/2009 09:48:9
000001312610 02/09/2009 09:54:4 02/09/2009 09:54:9
000001312610 02/09/2009 09:54:5 02/09/2009 09:54:9
000001312610 02/09/2009 10:07:0 02/09/2009 10:07:9
000001312610 02/09/2009 10:07:0 02/09/2009 10:07:9
000001312610 02/09/2009 10:16:5 02/09/2009 10:16:9
000001312610 02/09/2009 10:16:7 02/09/2009 10:16:9
Similarly I get the Endtime and ENd dayfrom other table for same work item.So my requirement here is
in the it should show the display in a single cell .as, 5secs, 5 secs,4 secs,9secs,4 secs,2 secs
for each work item.
Can any body help me on this issue.
Any pionters for this are much helpful for me.
Thanks
Rohini.