Hi,

I have this data set where a value (column A) is assigned a fixed time (column B).
the min for the value is -27.49, the maximum is 16.14.
for the time is the minimal 30 minutes, and the maximum several hours (in steps of 30 minutes)

I want to view all these values according to the time they are assigned in a histogram.
So I want a histogram with bins of 30 minutes where:
bin1: 15-45 minutes
bin2: 45-75 minutes
etc. etc.

the data type of column A is general, of column B is time (hours:minutes:seconds)

how can I do this in excel 2016, because when I try to use histogram I get a blanc graph.

Thank you in advance!




part of the DATA

-27.49 08:30:00
-21.6 15:00:00
-15.93 06:00:00
-14.98 09:30:00
-14.66 08:30:00
-14.12 13:00:00
-12.34 07:00:00
-12.33 10:00:00
-11.6 14:00:00
-11.42 12:00:00
-9.81 07:00:00
-9.64 07:30:00
-9.11 06:30:00
-9.02 07:30:00
0.97 00:30:00
0.97 02:00:00
0.97 02:30:00
0.97 01:30:00
0.97 05:00:00
0.97 00:30:00
0.98 01:00:00
0.98 02:00:00
0.98 01:00:00
0.99 03:30:00
0.99 01:30:00
0.99 01:30:00
5.56 01:30:00
5.65 00:30:00
5.83 12:00:00
6.7 04:00:00
6.79 01:00:00
7.11 01:30:00
7.31 00:30:00
10.35 09:30:00
12.77 01:00:00
13.15 02:00:00
16.14 01:30:00