MROUND(F2,TIME(0,0,5))
 

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

MROUND(F2,TIME(0,0,5))
 

The value in F2 is probably entered as Text.

In article . com,
"ditchy" wrote:

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

MROUND(F2,TIME(0,0,5))
 

On Apr 3, 2:24 pm, JE McGimpsey wrote:
The value in F2 is probably entered as Text.

In article . com,



"ditchy" wrote:
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- Hide quoted text -

- Show quoted text -

Thank You for your prompt reply,
F2 is formatted as hh:mm:ss
Opened the workbook today and all is working as normal, Gremlins?
thanks again
Ditchy