formula that calc the diff in time, with a less than function?

G

Guest

I need a formula that calculates the difference in 2 times but if the
difference is less than a certian amount of minutes i want the cell to show
pattern or something dis-allowing cell entry example: 1:00 + 2h:15m= 3:15
(the 2hr 15 comes from another cell) in the cell next to 3:15 is where I need
the formula to calculate the same as the other but if the difference between
the 2 cells is less than a specific amount of minutes i want the cell to show
a pattern or text or some indicator that to little time is in between what is
allowed. Any help?????
 
G

Guest

Subtract one time from the other and use conditional formatting to highlight
undesirable times.
HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function to vlookup and put between? 1
LOOOOONG formula, with drop down selection 1
HELP! I need to make an IF Statement comparing date/time fields.. 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Make a cell not equal less than a certain number 5
Formula or Function? 4
Can system time & date be nested in conditional formula? 1
Difference between two date/time values 5

Top