Friday, August 1, 2014

yogi_Conditionally Format Time Duration (as +ve or -ve) In Cells K4 To K (G4 To G minus J4 to J)

                          Google Spreadsheet   Post  #1719
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Aug-01-2014
post by nebmot:
negative time shows up incorrectly
See attachment.

I have the following formula to calculate the difference in duration between G4 and J4 =IF(G4="","",G4-J4) in K4.

I'm using the following text format:


I want negative numbers showing up as green -0:00.13 in K4 instead of the -59:59.87, what am doing wrong? 

Attachments (1)
Screenshot 2014-07-27 16.01.59.png
14 KB   View   Download