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 Slack's direct listing "IPO" is a good idea?

Discuss in The Lounge

Poll History