View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default limit on [h]:mm time format?

From XL Help ("Specifications"):

Largest amount of time that can be entered 9999:99:99

Calculated times can be larger (at least 66600000:00:00.

In article ,
Stefi wrote:

Hi All,

[h]:mm time format seems to work only up to 9999 hours, XL2003 doesn't
handle 10000 hours as time, 10000:00 remains text. Is this an unchangeable
limit?

Thanks,
Stefi