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     www.energyefficientbuild.com.   Aug-01-2014
post by nebmot:
(https://productforums.google.com/forum/#!mydiscussions/docs/7ZeGpT6U7ZQ)
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:

m:ss.00;[Color10]\-m:ss.00

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
-------------------------------------