Consumer Electronics introduced
Excel Magic Trick 626: Time Gantt – Conditional Formatting and given? Are personalized? Es validation formulas
See how cr? First Gantt chart for the H takes? This time? project w? Show during a common day e. Learn more about: 1) Time Math 2) Conditional Formatting with the OR function in a logical formula 3 num? Ros hide) validating given? Are with the Custom option, with a logical formula that uses ROUND functions and op? tors for comparison case, preventing many hours re? u the formula. 4) with Conditional Formatting function and cr? First Gantt chart in the cells. ! Vid? Bones like: Excel Magic Trick 565: 564 Excel 2010 Excel Gantt Daily Magic Trick: Daily Gantt
-
#4 written by Noumenon72 1 year ago
@ExcelIsFun Thanks for replying — you’re so reliable after all this time. I did watch #501 first, hope I didn’t miss anything.
If I start a new worksheet (Ctrl-N) and type 10:58 PM in B1 (it displays 10:58:00 PM when I click there), =B1=NOW() returns false. I think it’s the seconds, but I can’t get rid of them.
I’m tracking in 15 minute blocks, so I am going to round NOW() to the nearest quarter hour. I still can’t use the equality sign, but I can use > and < in my rule and get close.
-
#5 written by ExcelIsFun 1 year ago
This video has most of what I know about time:
Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples)
What is giving you “4:00 AM”? Are you typing it in, is it be produced by a formula? If it is text “4:00 AM” that would be different than 4:00 AM.
If 4:00 AM in in a cell, say B1, then this formula would tell you if 4:00 AM = NOW():
=B1=NOW()
It would give you TRUE if it was 4:00 AM and FALSE if it was not.
-
#6 written by Noumenon72 1 year ago
I Googled time functions for 45 minutes and none of them explained that times are in fractions of a day. That’s so essential to doing the math! You helped me figure out that I can extract the time element from NOW() by subtracting TODAY() (why not just TIMEVALUE(NOW(), Microsoft?).
But, I still can’t compare “4:00 AM” to NOW() to see if they’re equal — even if I truncate them to three decimals. What would you do, Excel magic guy?
-
- Comment Feed for this Post
You are welcome!