time format in excel spreadsheet

[SMH]

I have a excel spreadsheet with a macro program. which is shared between two
machine. In one machine a cell with numeric zero when formatted to time shows
value as 12:00:00 and in the other machine it shows 00:00:00.

The macro which is looking for 12:00:00 therefore does not work as the value
is 00:00:00. Both machine are running the same version of EXCEL 2003

I cannot get the cell to read a numeric zero when formatted to time to
display 12:00:00 AM in the second machine.

Please advise and thanks in advance

[Toppers]

Hi,
It suggests the cells are formatted differently in the spreadsheets:
in one case format is hh:mm:ss which gives 00:00:00 whereas a format of
hh:mm:ss PM gives 12:00:00 AM.

HTH

"SMH" wrote:

> I have a excel spreadsheet with a macro program. which is shared between two
> machine. In one machine a cell with numeric zero when formatted to time shows
> value as 12:00:00 and in the other machine it shows 00:00:00.
>
> The macro which is looking for 12:00:00 therefore does not work as the value
> is 00:00:00. Both machine are running the same version of EXCEL 2003
>
> I cannot get the cell to read a numeric zero when formatted to time to
> display 12:00:00 AM in the second machine.
>
> Please advise and thanks in advance

[SMH]

Thanks will try it and hopefully it will works

"Toppers" wrote:

> Hi,
> It suggests the cells are formatted differently in the spreadsheets:
> in one case format is hh:mm:ss which gives 00:00:00 whereas a format of
> hh:mm:ss PM gives 12:00:00 AM.
>
> HTH
>
> "SMH" wrote:
>
> > I have a excel spreadsheet with a macro program. which is shared between two
> > machine. In one machine a cell with numeric zero when formatted to time shows
> > value as 12:00:00 and in the other machine it shows 00:00:00.
> >
> > The macro which is looking for 12:00:00 therefore does not work as the value
> > is 00:00:00. Both machine are running the same version of EXCEL 2003
> >
> > I cannot get the cell to read a numeric zero when formatted to time to
> > display 12:00:00 AM in the second machine.
> >
> > Please advise and thanks in advance