Excel Formula - If Time Difference is less th

March 28, 2011 at 04:59:06
Specs: Windows 7
I have an excel 2010 sheet showing a starting and ending time, I have the resulting difference in another cell, I want to create another colume that calculates if the time in a cell is LESS THAN X:XX minutes and seconds, then return TRUE.

See More: Excel Formula - If Time Difference is less th

Report •

March 28, 2011 at 15:24:05
It can be done, but it can be tricky, depending on how you have everything set up.

Post an example of how you have your sheet set up.

Read this to learn how to use the < PRE > tags to line up your data:


Here is an example you can tryout:

     A          B          C      D
1) Start       End       Diff	
2) 5:00:00   5:50:00   0:50:00   TRUE

The formula in cell D2:

If cell C2 less than 55:00




Report •
Related Solutions

Ask Question