time related success/fail

Hi

Looking for some assistance reporting service provider ticket performance SLA’s:

Q) In short, does anyone know how to uphold source vlookup reference data format (i.e. return 00:12:00:00 [dd:hh:mm:ss] data format through instead of 0.5 [General format]), through Vlookup?

Here’s the full scope of my issue:
I need to represent whether a volume (monthly set) of tickets have been resolved within their SLA period.
I’ve setup a simple vlookup query to determine what the target time should be, however my main issue is with regards validating against the reported time taken – here’s an example:

Reported fault time:
8d 15h 18m 54s
3d 5h 3m 20s
0d 4h 54m 40s

Not the most desirable format, but I can manipulate using text to column so results in the following format:

Reformatted fault time (Column A):
8:15:18:54
3:5:3:20
0:4:54:40

The issue I have is when using an IF(Vlookup) function to query whether the above is within SLA. The Vlookup returns the SLA time period in a basic number format of 0.5. Whereas, in order for the query to work should maintain source reference format of 00:12:00:00 … anybody any ideas?

* This may be an issue with manipulating the date into the correct format, so any ideas on that would be great!!

Many thanks
Greg

A formula cannot bring back anything from the reference cells in regard to formatting. You will need to apply the desired formatting to the cell with the formula itself.

post a workbook demonstrating this problem. Let us see the data, your current results, and manually mockup the desired results.