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

D

ditchy

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
 
D

ditchy

The value in F2 is probably entered as Text.



- Show quoted text -
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MROUND time 2
Rounding to the nearest quarter hour no longer working 4
Mround to nearest 5 c 1
mround 2
MROUND on a negative number. 6
Rounding a Calculated Percentage to the Nearest 5 9
Rounding to the nearest quarter (decimal) in a Pivot table 3
MROUND and negative/positive numbers 4

Top