Forum Discussion
Adding hours
This is an issue I had for a while but being just a personal project I haven't really pushed on working it. However, based on the knowledge here, opposed to the general internet, I want to try this ...
The TEXT function, as its name implies, returns a text value. The SUM function ignores text values.
Change the formula to
=B16-A16and set the number format to the custom format [hh]:mm
The SUM formula should then work as intended. Format the cell with this formula as [hh]:mm too.
Well, that is a super stupid simple solution! Thanks again!