Rounding hours (from 30 to 30 minutes)

Does anyone have any idea of some logic for rounding time, 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
 4
exceltime
Author: Math, 2015-07-14
Source

1 answers

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 this: 

=MARRED(A2;"0:30")

To always go down, do this: 

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

Result:

insert the description of the image here

 7
Author: Math, 2015-07-14 13:36:05