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).

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.

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

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History