how do I change the format of a cell with a negative time “-HH:MM” to RED txt?
ps I need the time to roll over, ie +24 hours. 70, 80, 90, hours may be needed. 24 hour limit is of no use to me.
Use [HH]:MM:SS;[RED]-[HH]:MM:SS cell format.
PS: Don’t “answer” questions with new questions or with clarifications to original questions. If the original question is yours, and you want to clarify, then edit it to add new data; if not, and if you are asking a new question, then create new question for that.