maheshrk81
Board Regular
- Joined
- Jan 5, 2010
- Messages
- 153
Hi All,
I have below tables which shows Query received time and Query resolved time. Now i need a formula in Column C to show, if the query is resolved with 24 hours or after 24 hours. Can someone please help
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Thanks,
Mahi
I have below tables which shows Query received time and Query resolved time. Now i need a formula in Column C to show, if the query is resolved with 24 hours or after 24 hours. Can someone please help
Query Received | Resolved | Duration |
2017-10-17 10:16:15 | 2017-10-18 11:39:59 | More Than 24 Hours |
2017-10-17 10:16:15 | 2017-10-17 00:16:15 | Less Than 24 Hours |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Thanks,
Mahi