VBA
Posted on February 25th, 2014
[Excel]
- Add time: http://office.microsoft.com/en-us/excel-help/add-times-HP003056109.aspx
Use function: TIME(h,m,s) - String compare: http://superuser.com/questions/284022/comparing-two-strings-in-excel
=IF(A1=B1,"true","false") - Count numbers greater than or less than a number: http://office.microsoft.com/en-us/excel-help/count-numbers-greater-than-or-less-than-a-number-HP003056117.aspx
- Convert column index into character : http://stackoverflow.com/questions/12796973/vba-function-to-convert-column-number-to-letter
轉成 26 進位的方式 - Range : http://stackoverflow.com/questions/13157363/create-excel-ranges-using-column-numbers-in-vba
[Time]
- Date to string : http://stackoverflow.com/questions/2636157/excel-date-to-string-conversion
=TEXT(A1,"DD/MM/YYYY hh:mm:ss") - Converting Time into Minutes : http://www.proworkflow.com/blog/2009/02/converting-time-into-minutes-using-excel/
http://stackoverflow.com/questions/14455803/how-to-convert-hoursminutesseconds-into-total-minutes-in-excel
- Type define : http://www.vb6.us/tutorials/user-defined-types-udt-vb
