Useful Excel Formula

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