Hello. I have a Google Sheets here and I need to calculate the entire of column of "1" "2" to "3" which is next to 1 & 2. Currently, the third column displays the time but I would like it to display text telling me if it's past the time of box 2.
To be more specific, column 1 tells me the time of when something happened and column 2 takes the time next to it and adds 4 hours, or it should anyways. I would like column 3 to tell me in real time (AEDT timezone) when the time has passed from column 2.
Not required, but the second image provided shows a table with something that I'd like. The time I've recorded something of was 2:34 PM in the first column, so the second column takes that time and adds 4 hours (6:34 PM or 18:34) and if the time is actually passed 6:34 PM or 18:34, the third column would show some words or basically anything obvious that tells me if the time has passed from column 2.
Really difficult to explain... Let me know if you have questions.