New answers tagged date-time
Here is an region-independent to get date and time. @echo off for /F "usebackq tokens=1,2 delims==" %%i in ( `wmic os get LocalDateTime /VALUE 2^>NUL` ) do if '.%%i.'=='.LocalDateTime.' set ldt=%%j set ldt=%ldt:~0,4%-%ldt:~4,2%-%ldt:~6,2% %ldt:~8,2%:%ldt:~10,2%:%ldt:~12,6% echo Local date is [%ldt%] output: Local date is [2015-10-02 20:10:00.000] ...
The weekday will be shown on your horizontal taskbar when you either Have Small Taskbar Icons enabled and the Taskbar is at least 3 rows high or Have Small Taskbar Icons disabled and the Tasbar is at least 2 rows high If you use the vertical taskbar You need to have it at least 80 pixels wide @ 100% scaling If you can't pull on your taskbar to ...
Go to taskbar properties & UN-check "Use small taskbar button". When you use the small taskbar buttons there is not enough room for the date unless you increase the taskbar size. [Not using small buttons]
I was not able to drag the taskbar to make it bigger until I unchecked "lock the taskbar" in the property section
You can use Sumproduct and evaluate the time of day with the Hour() function: =SUMPRODUCT(--(HOUR(H5:H29)=9))
You can add the day by customizing the short date in Region settings to dddd/dd/MM/yyyy, dddd for the day name, dd day date, MM month as number, yyyy year e.g. 2015.
Top 50 recent answers are included