The goal I have in mind is to plot the different types of losses on a linear time axis to show that the losses occur in groups around the same moment.

For this goal I have a set of data on sheet 1 that looks like this:

```
Column A Column B Column C
Time Type of loss Loss
1/1/2016 12:00:00 4,5 or 6 between -2000 and + 2000
```

The date times are all just minutes with no extra seconds.

In another sheet (sheet 2à I want to format the data like this

```
Column A Column B Column C
Time Loss type 1 Loss type 2
1/1/2016 0:00:00 Losses at that moment Losses at that moment
1/1/2016 0:01:00 " "
etc..
```

So I used index-match to lookup the values of time and loss type. This didn't work because there were slight differences between the times. I then proceeded to use this formula on sheet 2 that includes the round function to lookup the losses.

```
=INDEX(Sheet1!$C$2:$C$1000,MATCH(ROUND($A2,3)&B$1,ROUND(Sheet1!$A$2:$A$1000;3)&Sheet1!$B$2:$B$1000))
```

The problem is that for some datetimes this rounding works and for others it doesn't. The question I have is: Is their a set number of digits I should round at or is their another solution for my problem?

`ROUND`

on a date in the fashion you want it to work. Look at this article. It has some information on how to achieve rounding on a hour/minute basis. It's more complicated than just using`ROUND`

.3more comments