time format
 

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

time format
 

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

time format
 

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