LogFAQs > #912242169

LurkerFAQs, Active DB, DB1, DB2, DB3, Database 4 ( 07.23.2018-12.31.2018 ), DB5, DB6, DB7, DB8, DB9, DB10, DB11, DB12, Clear

Topic List	Page List: 1
Topic	Save My Favorite Final Fantasy Characters XX: Day 91 (RULE CHANGE) [smfffc]
MartinFF7 11/11/18 8:46:53 PM #269:	th3l3fty posted... it'll probably be easier than the times one for some reason `=$C2-$B2<10000` works but `=$C2<$B2+10000` doesn't and it makes no sense at all Just downloaded the file to give it a look... my guess is, because the numbers are being saved formatted as text instead of numbers, the conditional format check stops as "c2<b2" because it's text compared to text... or something... that is definitely a weird one though. The columns were probably set to Text-format when you were pasting in the hh:mm:ss timestamps, since you're just dealing with pure numbers now you could change them back to General format, so any number you paste in would be number-formatted itself and then the second formula would compute normally? <cite>MartinFF7 posted [p:912242169] in Save My Fa... [t:77193140]...</cite> <quote><cite>th3l3fty posted...</cite> <quote>it'll probably be easier than the times one for some reason =$C2-$B2<10000 works but =$C2<$B2+10000 doesn't and it makes no sense at all</quote> Just downloaded the file to give it a look... my guess is, because the numbers are being saved formatted as text instead of numbers, the conditional format check stops as "c2<b2" because it's text compared to text... or something... that is definitely a weird one though. The columns were probably set to Text-format when you were pasting in the hh:mm:ss timestamps, since you're just dealing with pure numbers now you could change them back to General format, so any number you paste in would be number-formatted itself and then the second formula would compute normally?</quote> ... Copied to Clipboard!
Topic List	Page List: 1