Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.