Negative time, hours

Welcome to the forum.

The second question is the easiest to answer: format your time cells using the custom format [h]:mm and the hours will add up to as many as you need, not reset at 24.

Getting negative numbers to display is a bit more problematic, but possible. First, use this formula in C21 - it will display the number of hours owed or accrued as a positive number, regardless of whether the result actually is positive or negative:

Formula:

Please Login or Register  to view this content.

Now, go to Conditional Formatting ('Home tab', 'Styles' section), click 'New Rule' then 'Use a formula to determine which cells to format'. Enter this in the formula box:

Formula:

Please Login or Register  to view this content.

Now click the 'Format' button, go to the 'Number' tab, select 'Custom' on the left-hand side, then enter this in the 'Type' box on the right:

Formula:

Please Login or Register  to view this content.

This will force positive hrs:mins to display as red hrs:mins with a minus sign, and negative numbers and zeros to not have a minus sign (the @ at the end tells it to accept text as typed).

Does that do what you want?

You're welcome - thanks for the feedback.

So that others know there's a solution here, please mark this thread as [Solved] by going to 'Thread Tools' above your first post and selecting 'Mark this Thread as Solved' - thanks.