Or, how to edit gmail csv-file (which was export­ed from gmail) with cor­rect way …

Con­tin­ue read­ing →

con­vert the time in A1 to text. 

=TEXT(A1,"hh:mm")

code, which use for macro in excel
Con­tin­ue read­ing →

The fol­low­ing macro will enter the cur­rent date and time in the active cell with­out mov­ing the cur­sor. The date and time will be entered as a dat­e­val­ue, mean­ing that it will not change every time you open the workbook.
Con­tin­ue read­ing →