With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.energyefficientbuild.com. Aug-01-2014 post by nebmot: (https://productforums.google.com/forum/#!mydiscussions/docs/7ZeGpT6U7ZQ) negative time shows up incorrectly
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?