This is probably really basic but I can't for the life of me get this to work. I have 2 cells that contain a date and a time, cell a and B. In order to calculate duration I have added these two cells together and formatted the cells as [h]:mm:ss. I would now like to calculate the percentage of calls that were made in 15 mins or less. My formula is =If(c2<0:15:00,1,0).
What am I missing here?