Looking for your help, so we have a project manager that has the below information on a sheet. And what he is looking for, is to have a column that calculates how many hrs left each row has before it reaches its planned end date/time.
That way they can either add filters or conditional formatting for the rows that are due imminently etc. So would love to know if there is a way around this.
Secondly, there is an ask that it it be calculated using CT time zone? However that wont be possible would it? As the time zone of the sheet, is determined by the user logged in? Or is there a way to work that out also?
Thanks in advance!
