Forum Discussion

J-Des000's avatar
J-Des000
Brass Contributor
Aug 01, 2024
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 ...
excel
Excel on Mac
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Aug 01, 2024

    J-Des000 You may try-

    =IF(TIMEVALUE(TEXT(NOW(),"hh:mm:ss"))<TIME(6,0,0),SUM(A1:A3),0)

     

     

Harun24HR's avatar
Harun24HR
Silver Contributor
Aug 01, 2024

J-Des000 You may try-

=IF(TIMEVALUE(TEXT(NOW(),"hh:mm:ss"))<TIME(6,0,0),SUM(A1:A3),0)