HI All ,
i have on excel sheet with call data now i need calculate below parameters. Response time calculation If call Type M (Ticket date -Eng IN Time) Service window according to Customer working Days and Start Time , End time and also match the holidays according to branch name (sheet holiday date) Down time calculation If call Type M (Ticket date -Eng Out Time )Service window according to Customer working Days and Start Time , End time , Response time calculation If call Type P (Dispatch time -Eng IN Time) Service window according to Customer working Days and Start Time , End time , Down time calculation If call Type P (Dispatch time -Eng Out Time) Service window according to Customer working Days and Start Time , End time , Total Working Hrs for month when Eng Out according to service window, Uptime% calculation ( Uptime/Total working hrs)
TIA
i have on excel sheet with call data now i need calculate below parameters. Response time calculation If call Type M (Ticket date -Eng IN Time) Service window according to Customer working Days and Start Time , End time and also match the holidays according to branch name (sheet holiday date) Down time calculation If call Type M (Ticket date -Eng Out Time )Service window according to Customer working Days and Start Time , End time , Response time calculation If call Type P (Dispatch time -Eng IN Time) Service window according to Customer working Days and Start Time , End time , Down time calculation If call Type P (Dispatch time -Eng Out Time) Service window according to Customer working Days and Start Time , End time , Total Working Hrs for month when Eng Out according to service window, Uptime% calculation ( Uptime/Total working hrs)
TIA