Negative Time Calculation


J

John

I have the following formula that calculates the difference between an
employees clocked time and their amended times if manual interventations
have been made

=IF(K63="","",IF(AND(K63>0,K60=""),(K63-K59),(K60-K63))) <the cell is
formatted as [h]:mm>

The formula returns a ##### value when the above value is negative, however
I want to see the negative hours shown as -2:32 etc

Is this possible

Thanks
 
Ad

Advertisements

J

John

I believe that changing my base date to 1904 works, but that can cause
serious grief

Any other work around
 
J

John

FYI

I've changed the format to Number with 2 decimals and multipled the result
by 24 - seems to work

John said:
I believe that changing my base date to 1904 works, but that can cause
serious grief

Any other work around


John said:
I have the following formula that calculates the difference between an
employees clocked time and their amended times if manual interventations
have been made

=IF(K63="","",IF(AND(K63>0,K60=""),(K63-K59),(K60-K63))) <the cell is
formatted as [h]:mm>

The formula returns a ##### value when the above value is negative,
however I want to see the negative hours shown as -2:32 etc

Is this possible

Thanks
 
Ad

Advertisements

B

Beege

John,

Seems convoluted to have to do, but

=IF(K63="","",IF(AND(K63>0,K60=""),ABS(K63-K59),ABS(K60-K63)))
in your cell

=OR((K60-K63<0),(K59-K63<0))
in conditional formatting (make red if negative)

and you can keep your time formatting...

Beege
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative Time 7
Time / Negative Time 2
negative times. 1
negative 0 in calculation 6
Calculation & Negative Help 2
Displaying a negative time 3
negative time values? 8
PMT calculation is negative number 3

Top