Joining Round Function with If Statement

[bgates]

Hi,

Is it possible to join the following formulas:

= (ROUND((E6 * 1440) / 15, 0) * 15) / 1440

= IF(e6>MIN(F6,H6),e6-MIN(F6,H6),0)

I want to round to the nearest 15 minutes then do an "if" statement.

Bill

[reimar_rem]

Hi,

Kindly attached file.

I don't get your 1st formula. 1440/15 times 15/1440 will simply cancel your operation and leaving the value of e6.

=IF(ROUND(E6,0)>MIN(F6,H6),ROUND(E6,0)-MIN(F6,H6),0)

[bgates]

Hi reimar_rem,

The Round formula I posted above actually works for rounding to the nearest 15 minutes. Here's an example of what I'm trying to do:

E6,F6,H6
11:00,10:43,11:01

The answer should be 15, i.e. 11:00 minus 10:45 (10:43 rounded up to 10:45).

I've tried the following but it doesn't work:

= IF(E6>MIN((ROUND((F6 * 1440) / 15, 0) * 15) / 1440,(ROUND((H6 * 1440) / 15, 0) * 15) / 1440)),E6-MIN(F6,H6),0)

Any suggestions?

Bill