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
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.