time format and adding tiome values.

[dave m]

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

 

[Frank Kabel]

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]

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.

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)

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

 

[Frank Kabel]

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

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.

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)

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