Useful Excel Formula

Sum of Hours. Select cell that is the sum. Select Format->Format Cell Category-> Custom -> Type [h]:mm;@ Reference Show only the domain name of an email address where A1 has the full email address. =MID(A1,SEARCH(“@”,A1)+1,255)

How to send an HTML email using PHP?

<?php $to = “,”; $subject = “HTML email”; $message = ” <html> <head> <title>HTML email</title> </head> <body> <p>This email contains HTML Tags!</p> <table> <tr> <th>Firstname</th> <th>Lastname</th> </tr> <tr> <td>ABCD</td> <td>EFGH</td> </tr> </table> </body> </html> “; // Always set content-type when sending HTML email $headers = “MIME-Version: 1.0” . “\r\n”; $headers .= “Content-type:text/html;charset=UTF-8” . “\r\n”;