Ask Your Question

Negative time in red

asked 2018-04-11 01:06:47 +0100

Ivan Other gravatar image

updated 2018-04-11 08:08:51 +0100

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-04-11 08:12:26 +0100

updated 2018-04-11 08:14:07 +0100

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.

See guidelines for asking.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-11 01:06:47 +0100

Seen: 160 times

Last updated: Apr 11 '18