Search code examples
exceldatehour

Show first two digits of time that is over 24 hours

In EXCEL I have cells showing the total time of operations in HH:MM (rather than DD/MM/YYY HH:MM). I have formatted the cell so that instead of DD/MM/YYYY HH:MM, it shows the total hours (e.g. 01 day and 13 hours would show 37:00). So for example I am simply trying to show '37' in a different cell.

Solution

  • You can simply use =TEXT(Reference cell,"hh") along with your formula to find