how to convert this observationOffset into daily time intervals

[Gooooooy]

Hello, As we attempt to extract monitoring data from the vitalPeriodic table for our analysis, we have utilized the observationOffset as a timestamp. According to the information provided on the website, this parameter is described as the "number of minutes from unit admit time that the periodic value was entered."

However, we are wandering how we can correctly convert this observationOffset into daily time intervals? Does the "unit admit time" mentioned in the description refers to the ICU admission time, which is derived from the hospitalAdmitTime24+ hospitalAdmitOffset calculation in the patient table? What do positive and negative numbers of observationOffset and hospitalAdmitOffset mean respectively?