Hi
AFAIK this is the maximum Excel can display in the format [hh]:mm. You may
consider using a different format / calculation in this case if you have to
add such big time numbers (416 days)

"dave m" wrote:

when adding 2 times in the format hhh:mm:ss i get a #value error if the total
is greater than 9999:59:59 . it seems like a field limit. how can i over ride
this so the figures will return a true total.?