Hi Guys,
I'd like to know if there is a way to extract date and time with VBA based on an IF from a different cell, I can use =if(A1="Yes",Now(),""), however this formula will change the date and time every time the spreadsheet is opened or modify and I need the original date and time to calculate the time that took certain process to complete. Also I'd like to know if it is possible to calculate SLA in hours/minutes based on Start date/time and Closed date/time for example below, thanks for all your help.
<TBODY>
</TBODY>
I'd like to know if there is a way to extract date and time with VBA based on an IF from a different cell, I can use =if(A1="Yes",Now(),""), however this formula will change the date and time every time the spreadsheet is opened or modify and I need the original date and time to calculate the time that took certain process to complete. Also I'd like to know if it is possible to calculate SLA in hours/minutes based on Start date/time and Closed date/time for example below, thanks for all your help.
| A</SPAN> | B</SPAN> | C</SPAN> | D</SPAN> | F</SPAN> | |
| 1</SPAN> | Start</SPAN> | Date/Time</SPAN> | Closed</SPAN> | Date/Time</SPAN> | SLA</SPAN> |
| 2</SPAN> | Yes</SPAN> | 1/20/2013 13:25</SPAN> | Yes</SPAN> | 1/21/2013 2:40</SPAN> | 13 hrs 15 min (Closed date/time - Start date/time)</SPAN> |
| 3</SPAN> | No</SPAN> | No</SPAN> | |||
| 4</SPAN> | Yes</SPAN> | 1/20/2013 15:33:00 PM</SPAN> | No</SPAN> | Since this is NO Date/Time should be current date and time. |
<TBODY>
</TBODY>
