Issue with adding time elapsed that was pre calculated

[DawnDesM]

Hello,

Here is the table info I'm working with:

class status changeby changedate statustracking
INCIDENT- RESOLVED- Person A- 2/20/2014 9:05 -
INCIDENT- RESOLVED- Person b- 2/20/2014 11:57 -
INCIDENT- QUEUED- Person b- 2/19/2014 13:57 - 01:24:08
INCIDENT- QUEUED- Person c- 2/19/2014 15:21 - 19:29:58
INCIDENT- QUEUED- Person c- 2/20/2014 10:51 - 01:06:00

I need to be able to add the statustracking time together per person per status (so person c would need 19:29:58 + 01:06:00 added together). Access keeps trying to add dates to the field or reconfigure the numbers to date\time or zeros if I use any of the data type other then Memo or text.

Not sure what I'm attempting can be done and thought I would ask here prior to driving my head through the wall

Hope I'm making sense here

Thanks
Dawn

 

[WaiveIt]

IDK, maybe try changing the format of the control that displays the data.