Time ROUNDUP or ROUNDDOWN

Assuming you want to round up/down to the quarter hour (15 minutes), then one way is to do something like this:

The formula to round down, in B2, with the original time in A2::

=TIME(HOUR(A2),FLOOR(MINUTE(A2),15),SECOND(A2))

The formula to round up, in D2, with the original time in C2:

=TIME(HOUR(C2),CEILING(MINUTE(C2),15),SECOND(C2))

The formulas are the same except that one uses FLOOR and one uses CEILING.

If your region uses , as a decimal separator replace the , in the formulas with ; .

SG

If you have durations in, say, A2 and C2, then you can do something like this:

In B2, with the original duration in A2:

=DURATION(,,,FLOOR(DUR2MINUTES(A2),15))

In D2, with the original duration in C2:

=DURATION(,,,CEILING(DUR2MINUTES(C2),15))

If this still isn't what you are looking for you could try posting a screenshot.

SG

Confusing. In your post you state you want to round up or round down "time values". So you mean those are not date-time but are duration?

SG