Hello
The macro below works well for converting military time to regular time and adjusts the one difference in timezone. I would like to round up the outputted time by quarter of the hour as I am currently doing it manually after running the macro using the MROUND function. Ex 05:20=05:30 & 20:55=21:00
<tbody>
</tbody>
The macro below works well for converting military time to regular time and adjusts the one difference in timezone. I would like to round up the outputted time by quarter of the hour as I am currently doing it manually after running the macro using the MROUND function. Ex 05:20=05:30 & 20:55=21:00
MATCH | 620 | 05:20 | ||||
DATA | 1310 | |||||
DATA | 1540 | |||||
MATCH | 2155 | 20:55 |
<tbody>
</tbody>
For Each Cell In Range("C2:C" & Cells(Rows.Count, 3).End(xlUp).Row)
If Cell.Value = "MATCH" Then Cell.Offset(, 1).Value = TimeValue(Format(Cell.Offset(, 4).Value, "0\:00")) - TimeValue("01:00")
Next