EXCEL Formula - COUNTIF

Salah satu rujukan:

Ref: https://www.ablebits.com/office-addins-blog/2014/07/02/excel-countif-examples/

ANDROID - Nak clear catch

Senang jee...

http://www.greenbot.com/article/2841772/clear-your-app-caches-to-clear-up-android-phone-issues.html

Tapi whatsapp bikin hp aku selalu hang... banyak gambar & video... banyak yg ulang tayang :(...

Dah tak masuk tahap tak boleh "CLEAR CONVERSATION" dah... Bila cuba nak "clear"kan... lagi teruk "hang"nya :(... Jadi pilihan yg ada sekarang.... delete satu-satu... :(

EXCEL Formula - How To convert Excel Time (HH:MM:SS) To Second.

From Google search... found this link:

http://www.excelfunctions.net/seconds-to-time-excel.html

As times in Excel are simply numerical values, a specified number of seconds can be converted to an equivalent time value through simple arithmetic.

The decimal value representing 1 second in Excel is calculated as follows:

1 second = 1 / 86400

I.e. 1 second = 1 divided by the number of seconds in a day.

Example below:

Ref: http://www.excelfunctions.net/seconds-to-time-excel.html

Brs,
AZH

Restore Win 7 tapi lupa password pulak... Macam mana nak setel...bahagian 2

Kaedah yg sebelum ni dah dicuba tapi tak berjaya...

InshaAllah akan tiru kaedah seperti dlm link dibawah pula...

http://www.proyectobyte.com/hirens-boot-2/hirens-boot-cd-15-2-usb-2014-everything-one-cd?lang=en

Restore Win 7 tapi lupa password pulak... Macam mana nak setel...

Assalamu'alaikum.

Tanya mr Google... "

How to Reset Your Forgotten Windows Password the Easy Way"

Macam biasa banyak pilihan yang dia kasi...

Aku pilih yg ni :

How to Reset Your Forgotten Windows Password the Easy Way

http://www.howtogeek.com/96630/how-to-reset-your-forgotten-windows-password-the-easy-way/

- Aku boot pakai Win7 installation CD.

- Win 7 Window pop-up >>> Next

- Win 7 Install Now pop-up.... aku pilih "Repair your computer"

- System recovery Options status bar bergerak2 ... scan mende ntahh...

- Selepas habis scan... aku pilih "Next"

Sekali keluar window pop-up dan tertera mesej yg mengatakan os dlm NB aku & installation CD tak ngam... so tak boleh proceed....

So aku browse youtube plakkk...

https://youtu.be/Z13fLYiFRCg 

(How to Reset/Recover Forgotten Windows 7 Password by AvoidErrors)

Dia sarankan guna 3rd party sw... Hiren's Boot CD... Saiznya 593MB (HirensBootCD 15.2)

Aku download di sini:

http://www.hirensbootcd.org/download/

La ni tengah download lg :|... 

Sambung selepas ni.