TimeClock june-dec. 2012.xls.zip
i can not figure out why i am getting a #VALUE! error in cell AI5869
Thanks
TimeClock june-dec. 2012.xls.zip
i can not figure out why i am getting a #VALUE! error in cell AI5869
Thanks
Last edited by wilbilj; 01-04-2013 at 12:22 AM.
Two things...
* Look for negative time. Excel don't like that. To exclude you can use =SUMIF(...;">0")
* Maximum time format is 9999:59:59. After that it becomes text. http://support.microsoft.com/kb/214386
Check =ISTEXT(...)
//Ola
Mark the problem as Solved under the Yellow bar up Top right, under Thread Tools, when you received a solution.
It saves time, to skip already solved threads.
"please rename your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it of interest to them, or falls within their area of expertise, and will only open those threads. also, searching for ""help"" will not turn up too many results that will benefit you, sorry
when you name a thread, think ""google"". what kind of returns would you expect if you typed that into google?"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi wilbilj
Start with converting all your numbers & dates to real numbers & dates.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks