[Year 12 Its] off topic (a little) sharing data between databases and spreadsheets

[Bricks J. Winzer]

>>but stubbornly receive 11A as .485333333 and 12A as 0? It is clearly
>>importing it in a numeric form despite all attempts to format the
>>receiving cells as text.

> Looks like the data is importing as numerical time. For example 11AM
> calculates to 0.4583333333333 and 12AM is 0. Excel calculates date
> and time as number of days from a reference date (1/1/04 I think)
> and time as a fraction of a date (hence 11am being 11/24 or
> 0.458333333...). No idea how this is affected by your importing but
> it seems that for some reason Excel is ignoring your desire for the
> column to be text and converting the time to a number.

Depending on regional settings, "11a" and "12a" can sometimes be
entered to represent 11 and 12 AM.  Rob, it might be worth testing
how 11P and 12P are imported, should confirm Michael's observation
(great spot by the way!  I wouldn't have guessed that).

----------
B.J. Winzer
St Columba's College
Essendon