Excel

Excel calculated value in a text string

http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx

="Buy In $50 Pot - Total Pot Winning pot " &TEXT(COUNTA(A3:A21)*50,"$0.00")

Calculate for non blank values

http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx

=IF(ISBLANK(D3),"",($C3/D3)-1)

Convert minutes to Hours and minutes

Format the cell as time format

=H13/1440

Macro to hide columns

Sub Button2_Click()

    Dim cl As Range, rTest As Range

     

    Set rTest = Range("d2", Range("d2").End(xlToRight))

    For Each cl In rTest

        If Not cl.Value = "blah" Then

            cl.EntireColumn.Hidden = True

        End If

    Next cl

End Sub

Substring

Servername

Datacenter      =MID(A2,17,3)

Product Code    =MID(A2,8,3)

Swimlane        =MID(A2,8,3) 

Type            =MID(A2,11,2)

Environment     =MID(A2,3,4)

Tier            =MID(A2,2,1)