Hello, I am having trouble with the MROUND & Time function. I have
this formula which gives me a time rounded to the nearest 5 seconds,
it was working when I used the workbook 2 weeks ago. And I don't
recall changing any programs?
MROUND(F2,TIME(0,0,5))
analysis toolpack is checked
but all I get is #VALUE
anyone help me out please
regards
Ditchy