I have the following function in several cells of an Excel worksheet. It returns results some of the time, but after certain events like copying the worksheet, it errors out to #value#. At that point I haven't changed formatting or values or anything, simply making a copy of the worksheet. Any ideas?
= TIME(HOUR(C1),MROUND(MINUTE(C1),30),0)+ ROUND(C1,0)
Thanks,
Fred
= TIME(HOUR(C1),MROUND(MINUTE(C1),30),0)+ ROUND(C1,0)
Thanks,
Fred