If a cell is formated as duration, as to show the time in HH:MM:SS, I cannot make it multiply by an integer.
Example: =F1*G1 where F1 value is 8:00:00 and G1 value is 3, should return 24:00:00 but returns 1 instead
Something formatted using the codestring HH:MM:SS
can’t be interpreted as a duration because it doesn’t even show multiples of 24 h. The “colon-formats” are made for TimeOfDay, and only if you accept the unchgangeable unit “day” (1 d) it can be misused as a duration format at all. However, if you do so you urgently should change it to [HH]:MM:SS
to at least allow for displaying values >1d. A bit better again would be [HH]" h "MM" min "SS" s"
. This is still a duration internally using the day as unit, and for getting the “number of hours” you need to multiply it by 24. If you want to display the result as a duration, you must not used a colon format! It wouldEither use h
as the unit with a decimal fraction, or convert to a different single unit. Also note that colon-formats whether used correctly for TOD, or wrongly for durations always show the down-rounded result.
And, if do you format the result cell as HH:MM:SS, you will get 00:00:00, because there are no a real 24:00:00 time in a day.