• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

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?
  • 2
1 Solution
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 the above discussion is not solving your problem, could you please post a sample workbook so the discussion can be specific to your situation?
You can calculate the percentage of differences that are 15 minutes or less with a formula like:
Rrave26Author Commented:
That worked perfectly.  Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now