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.
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?
ROUNDon 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