pramodagroiya
New Member
- Joined
- Feb 23, 2016
- Messages
- 4
Hi,
I have excel sheet, wherein we have ticket raise date and time & ticket close date and time. i need to calculate the time difference if the ticket is closed with 4 hrs to TAT or not. also if the ticket is created after 2:30 PM then the time calculation will be till 6:30 for TAT and rest of the TAT will start next day after 9:30 AM. need to exclude saturday and sunday.
sample file is like this:
<tbody>
</tbody>
I have excel sheet, wherein we have ticket raise date and time & ticket close date and time. i need to calculate the time difference if the ticket is closed with 4 hrs to TAT or not. also if the ticket is created after 2:30 PM then the time calculation will be till 6:30 for TAT and rest of the TAT will start next day after 9:30 AM. need to exclude saturday and sunday.
sample file is like this:
Ticket Number | Date | Help Topic | Source | Current Status | Last Updated |
158635 | 22-02-2016 09:32 | Featured Static Listing | Phone | Closed | 22-02-2016 12:32 |
<tbody>
</tbody>