I want to add hours and minutes in excel.
However when going over 24, the spreadsheet doesn't know what to do.
13:30 + 2:45 + 11:15
I tried changing the formatting to Time > 37:30:55 and it gave me 339:30:00
The cells that contain the time are calculated cells, which calculate the difference between two times of the day
The formatting for those cells is Time > 13:30