# IF statement using Time

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?
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mechanical EngineerCommented:
A duration suggests that you have two cells with date/time information and are looking at their difference. To see if it is less than 15 minutes, consider:
=IF(B2-A2<=TIME(0,15,0),1,0)

If the above discussion is not solving your problem, could you please post a sample workbook so the discussion can be specific to your situation?

Experts Exchange Solution brought to you by