excel pivot table nigth sleeping hours between 2 different days

hi,

I am trying to register sleeping hours per day.

However  I am not able to establish how to measure the sleeping time as some hours are recorded on the previous day and the rest on the following day.

Does anyone have an idea of how to calculate the whole night sleeping time?

Thanks, Juan