Hello. I have a sheet that utilizes time in 24hr format. There are some time calculations that result in how many hours an employee has left to work, and displays it in the 24hr format.
Is there a way to split the value and add text to have the cell show "11hrs 30 mins" rather than "11:30"...