Dear Excel experts,
I have a data in the below tabular format.
9:15:00
-7.53
9:16:00
-11.72
9:17:00
-6.32
9:18:00
-1.38
9:19:00
-8.25
9:20:00
-3.53
9:21:00
1.65
9:22:00
-2.12
9:23:00
4.62
9:24:00
10.51
1. As first column is time, I want to display HH:MM only. Can you...