I have a cell that sum other Time values in format `HH.MM.SS`

today the sum reached 24 hours and the total show is `00.00.00`

however it correctly consider 24 hours in other cells where calculate the total price. If I force the hours (enter manually) to 25, it show a `01.00.00`

and again correctly consider 25 and not 1 in the total price.

I need to either show the indication for days, for example something like `1 00.00.00`

or as alternative the total hours in the sum, for example `24.00.00`

or `25.00.00`

I guess that the format show time intended as time of the day and not total time, so I’m open to other solutions that allows me to perform the calculation `HOURS * PRICE`

considering the fraction of hours and minutes etc… currently the price formula is `= F146 * HOURLYPRICE * 24`

where HOURLYPRICE is a named cell containing the hourly price.