EXCEL PRO TIP: Real-Time Tools with TODAY & NOW

[@wayneedmondson1065]

Hi Chris.. thanks for the date and time tips. Another way to get just the current time with a single formula is: =MOD(NOW(),1) or another construct is: =NOW()-INT(NOW()) both of which strip out just the decimal value of the current day serial date/time value which is what you want for just the time. Always something fun at your channel. Thanks for all the great videos. Thumbs up!!