Skip to Content
0
Former Member
Apr 06, 2009 at 10:15 AM

How to calculate Time difference for a single line item

23 Views

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.