Question: how to change time in number excel?
Answer: Divide the numbers by 24 (there are 24 hours in a day). The formula can be as simple as =A2/24.
Select the cell(s) with the formula result, right-click and select Format Cells from the context menu or press Ctrl+1.