Time Format

[Todd]

Hi.

I am having trouble with a time format. The result of a
time calculation formula is 10:30. When I reference the
refer cell (=A1) the result is 9135062.00 I have tried
every time and custom opton in the Format Cells>Number box
but I can't get the result to read 10:30. Can someone
tell me what I am doing wrong?

Thanks,

Todd

 

[Frank Kabel]

Hi Todd
are you sure cell A1 is a time (could not think of a function which
would return this value as you only reference the resulting cell).

If you like you can email me your file and I'll have a look at it:
frank[dot]kabel[at]freenet[dot]de