Many client needs to display the time at the top or bottom of the dashboard. To achieve this most of the developer we used to call the function “=today()” in the excel level.
But to change the date format, we usually use to do the formatting by clicking the format cells of the context menu in excel. Instead of doing this practice, we have a option in component level to try various date & time format.
Might be a small hint, but these kind things saves lot of time rather than searching for the format in excel level.