Forum Discussion
Solved
Summing values based on certain time?
Is it possible WITHOUT using VBA to sum values if it's not a certain time on the clock (the live computer clock). For example, if before 6pm sum values and if after 6pm don't. I'd assume you have to ...
A similar formula but without any conversion to text
= IF(MOD(NOW(),1)<TIME(6,0,0), SUM(values), 0)