Hi all,

I am trying to create a pivot table that will be showing the utilization on an equipment that I am renting out.

Ideally, the pivot table will have the hours of operations 3AM to 11PM by hour, (21 lines) going down on the row axis and the dates on the column axis. Within the cells, I would like to have either a "YES" or "NO" depending on the report that I get.

See attached for sample report.example-rent.xlsx

Right now, I get a report that tells me the time in and time out. I did an "IF" function where depending on the Time In and Time Out, each cell will either spit out "Y" or "N".

I am having trouble figuring out how to pivot this report to get the hours of operation on the "row label" and how to get it to report Y or N within the values.

Any idea how I can do this?

Thanks