Solved Time Difference is less than 15 minutes

April 28, 2017 at 17:49:11
Specs: Windows 10
A2=10:00 am, B2=9:30 am, C2=0.30
If time difference result in C2 is less than 15 minutes, result should be B2 and if more than 15 minutes result should be B2+(A2-B2).

See More: Time Difference is less than 15 minutes

Report •

#1
April 28, 2017 at 18:20:07
If this is a programming question it should be here: https://www.computing.net/forum/pro... and it would be a help if more detail was included.

Report •

#2
April 29, 2017 at 10:15:40
✔ Best Answer
Judging from the A2, B2, C2 notation I would guess this is an Excel or Calc question.
If so, then the Office Software forum would be the best place to post the question.

As for the solution, try this:

Assuming that C2 is a calculated answer,
and that all cells are formatted as Time
then in cell D2 enter the formula:

=IF(C2<=TIME(0,15,0),B2,B2+(A2-B2))

See how that works for you.


MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question