Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Sub ConvertDateandTime() Dim cel As Range For Each cel In Range("A2:A" & Range("A2").End(xlDown).Row) cel.Value = cel.Value + Int(cel.Offset(0, 1) + 8 / 24) cel.Offset(0, 1) = cel.Offset(0, 1) + 8 / 24 - Int(cel.Offset(0, 1) + 8 / 24) Next cel Columns("B:B").Select Selection.NumberFormat = "hh:mm" End Sub
|Excel export Active Sheet in one workbook to a new sheet in another||8||23|
|Copy and Paste Text into Text Box||3||26|
|vba delte many shapes with same name||4||10|
|Sorting the values from table 1 to table 2, based on a required/ target percentage.||4||11|