Calculate time error

[wilbilj]

TimeClock june-dec. 2012.xls.zip

i can not figure out why i am getting a #VALUE! error in cell AI5869

Thanks

[olasa]

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

[FDibbins]

"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?"

[Kevin UK]

Hi wilbilj

Start with converting all your numbers & dates to real numbers & dates.