i am adding up some time durations and storing it in a variable. when the
variable is greater than 1, 1.384 for example, i need to format it in hours and
minutes and put the value in a cell. i keep only getting the hours greater than
24, 9:13:04, in this case.

format(variablename,"hh:mm:ss") is what i tried.

is there a way to format the number rather than doing the math to get 33:13?
--


Gary