Rounding of hours (every 30 minutes)

Asked

Viewed 12,788 times

4

Does anyone have any idea of any logic for rounding the hour, but every 30 minutes?

Example:

vem assim -> vira assim
15:34:32 -> 15:30 
15:47:21 -> 15:30 
16:00:40 -> 16:00
17:28:30 -> 17:00
excel time

  • Will always round down?

  • your solution is very useful, but as it is for employee break, passed from 16:00 to 16:00, passed from 16:30 to 16:30, passed from 17:00 to 17:00, understand?

  • 1

    See my issue

1 answer

7


Use the function MARRED (or MROUND if your Office is in English). It returns a number rounded to the desired multiple.

To use with schedules, do so:

=MARRED(A2;"0:30")

To always round down, do so:

=MARRED(A2-"0:15";"0:30")

Upshot:

inserir a descrição da imagem aqui

Browser other questions tagged excel time

You are not signed in. Login or sign up in order to post.