The only thing I can think of right now is
Format E9:E11 as "[h]:mm"Debug.Print Format(test.Value2, "dd:hh:ss") 'Or (2 variations) Debug.Print Format(test.Value, "[d]:hh:ss"):
The only thing I can think of right now is
Format E9:E11 as "[h]:mm"Debug.Print Format(test.Value2, "dd:hh:ss") 'Or (2 variations) Debug.Print Format(test.Value, "[d]:hh:ss")
Please take the time to read the Forum FAQ
Posting Permissions
Reply With Quote