sorting - Conditional time formula in excel -


i have column formatted "yyyy-mm-dd hh:mm:ss" (aka: datetime mysql). however, of times have not been set (ie. 00:00:00).

i'm guessing can't sort time-portion alone of datetime column in excel, think need formula determine if cell has time 00:00:00.

can shed light on issue?

i'm not sure want results, formula return true/false depending on if time portion 00:00:00

=mod(a1,1)=0 

Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -