u25103
11-14-2008, 03:14 AM
Hi
In a column i have time values, the values is imported from a text file as text.
I change the format to [h].mm
When i tried sum sum one or several cells and I'll end up with an error in the cell. The value in the cell should exceed 10000 hours
Now I read on microsoft webpage, that excel has a maximun time value set to 9999h.
Is there some way go around the problem?
Is there someone out there that has an idea to solve this one.
I guess this is not a real VB question, but I'm stuck.:dunno
Thanks (:help "PLEH")
In a column i have time values, the values is imported from a text file as text.
I change the format to [h].mm
When i tried sum sum one or several cells and I'll end up with an error in the cell. The value in the cell should exceed 10000 hours
Now I read on microsoft webpage, that excel has a maximun time value set to 9999h.
Is there some way go around the problem?
Is there someone out there that has an idea to solve this one.
I guess this is not a real VB question, but I'm stuck.:dunno
Thanks (:help "PLEH")