Format Date In VBA

[mouse88]

I have a function that uses the Date data type to return a value which is displayed as a time in my worksheet.

I am using the following to format the time:

SUMIFNOTERROR = Format(ReturnValue, "[hh]:mm:ss")

This chops off the hours and displays ":01:27".

Am I doing something wrong?

 

[Scott Huish]

Public Function SUMIFNOTERROR(ParamArray Values() As Variant) As Double
Dim v As Variant
For Each v In Values
    If IsNumeric(v) Then SUMIFNOTERROR = SUMIFNOTERROR + v
Next v
End Function