September 26, 2018
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)
About Author
