Avoiding Value error message due to space in cell w/ formula
Hi,
One way:
=IF(ISERROR(ROUND((SUM((((C16-B16)+(B16C16))*1440)/60)+(((E16-D16)+(D16E16))*1440/60))/0.25,0)*0.25
),"",ROUND((SUM((((C16-B16)+(B16C16))*1440)/60)+(((E16-D16)+(D16E16))*1440/60))/0.25,0)*0.25
)
HTH
Jean-Guy
"A.R. Hunt" wrote:
I have a time sheet in Excel that will be used by nearly 1000 employees. I'm
trying to make it both user friendly and foolproof. Currently, I have cells
for time in and out and then a cell that calculates the time worked. If
someone clears the "In" or "Out" cell with the space bar, the formula cell
returns a Value error message. How can I avoid this? Here's my formula:
=ROUND((SUM((((C16-B16)+(B16C16))*1440)/60)+(((E16-D16)+(D16E16))*1440/60))/0.25,0)*0.25
Thanks for any help correcting this or if you have suggestions regarding the
time formula I am very grateful.
A.R. Hunt
|