dimitrz
09-15-2008, 06:10 AM
Hi All,
I am trying to get a solution to this problem for a long time without any sucess - would be greatful if anyone here can help?
What I need to do is have a function which calculates the days elapsed between current date & time and a previous date & time and this calculation should stop when a Colum called Status ?closed or resolved ? is selected.
For example lets say in a tracker
Column B has Time in hours = 12:00
Column C has Date in this format = 15-March-2008
Column M = Status which has options like Open, Closed, Resolved, Onhold
Column O has Now() function formated to give Time in hours
Column P has Now() function formated to give Date like 15-march-2008
Now in column Q , I want the diffrence between O & B i,e how much hours has elpased since B till O eg 10 hours
Now in column R , I want the diffrence between P & C i,e how many days has elpased since C till P eg 7 or 14
However lets say if "Closed or Resolved " is selcted in Colum M then the counting should stop and the count till the closed was selected should be displayed in both Q & R cell.
Its a bit of a complicated query and no one has been able to resolve it till date. hence if you can resolve it I would be greatful to know how to do it.
I use excel 2003 and am a novice in Excel.
I have enclosed the sample tracker where I need to input the details
I am trying to get a solution to this problem for a long time without any sucess - would be greatful if anyone here can help?
What I need to do is have a function which calculates the days elapsed between current date & time and a previous date & time and this calculation should stop when a Colum called Status ?closed or resolved ? is selected.
For example lets say in a tracker
Column B has Time in hours = 12:00
Column C has Date in this format = 15-March-2008
Column M = Status which has options like Open, Closed, Resolved, Onhold
Column O has Now() function formated to give Time in hours
Column P has Now() function formated to give Date like 15-march-2008
Now in column Q , I want the diffrence between O & B i,e how much hours has elpased since B till O eg 10 hours
Now in column R , I want the diffrence between P & C i,e how many days has elpased since C till P eg 7 or 14
However lets say if "Closed or Resolved " is selcted in Colum M then the counting should stop and the count till the closed was selected should be displayed in both Q & R cell.
Its a bit of a complicated query and no one has been able to resolve it till date. hence if you can resolve it I would be greatful to know how to do it.
I use excel 2003 and am a novice in Excel.
I have enclosed the sample tracker where I need to input the details