Finding the Start Date and Time

[Yeft]

Hello There:

I'm wondering if some one can help with this:
I have an amount of elapsed hours for certain event that was triggered in the past , so how can I calculate the exact start Date and Time
when this was triggered based on todays date and time. Any help would be appreciated.
Thanks,

 

[snjpverma]

How about this?

B2-C2

 

[Yeft]

Hi, nope!, it does not work. Although I may have not explain well. I need to calculate the exact Date and time when the request was originated.

the working days are based on a 12 hours shift for aging or elapsed time since the request was triggered. Just need the exact Date and Time when it was triggered.. Please see
below:

 

[Fluff]

@Yeft in future please do not put your reply in quotes. Just use the quick reply window below the thread. Thanks

 

[Yeft]

@Yeft in future please do not put your reply in quotes. Just use the quick reply window below the thread. Thanks

I apologize, I'm not use to the site.

 

[Fluff]

Not a problem.