time format and adding tiome values.
 

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

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

tnks frank. my prob is these hrs are imported using a vlookup so the values
can be worked with. i have tried converting cells to general and then adding
and reconverting to time but this either fails or generates an invalid total.

"Frank Kabel" wrote:

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

Hi
what are your original values?. If you want to convert decimal numbers (such
as 40) to an excel time value (e.g. 40:00) you have to divide the value with
24

"dave m" wrote:

tnks frank. my prob is these hrs are imported using a vlookup so the values
can be worked with. i have tried converting cells to general and then adding
and reconverting to time but this either fails or generates an invalid total.

"Frank Kabel" wrote:

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