Laptop working pc not formula

[rfletcher35]

Hey guys,

Weird one, I have this formula that I use on my laptop =TIME(HOUR(G2),MINUTE(G2), SECOND(G2))

This works on my laptop but with the same install of Office 365 I get #VALUE! on my PC and it's driving me nuts, can anyone please help?

Thanks

Fletch

 

[MARK858]

What does the formula below return on the PC?

=ISNUMBER(G2)

Do the regional settings match on the PC and the laptop?

 

[rfletcher35]

=ISNUMBER(G2) return FALSE

 

[rfletcher35]

Sorry also I have gone through all settings in Options and checked that the cells formatting is identical too, it just doesn't make sense

 

[MARK858]

=ISNUMBER(G2) return FALSE

Then the cell content is text and so not a real date

Sorry also I have gone through all settings in Options and checked that the cells formatting is identical too, it just doesn't make sense

Not in your Excel settings, your Windows regional settings.

 

[Dave Patton]

What is in G2.
N.B. You can post an extract of your sheet with the forum's tool named XL2BB.
The third example has a space before and after the text

Time 2023.xlsm
	G	H	I	J
2	12:55:15	12:55 PM	TRUE	17
3	12:55:15	12:55 PM	FALSE	8
4	12:55:15	#VALUE!	FALSE	9
1d

Cell Formulas
Range	Formula
H2:H4	H2	=TIME(HOUR(G2),MINUTE(G2), SECOND(G2))
I2:I4	I2	=ISNUMBER(G2)
J2:J4	J2	=LEN(G2)

formatted General

Time 2023.xlsm
	G	H	I	J
2	0.538368	12:55 PM	TRUE	17
3	12:55:15	12:55 PM	FALSE	8
4	12:55:15	#VALUE!	FALSE	9
1d

Cell Formulas
Range	Formula
H2:H4	H2	=TIME(HOUR(G2),MINUTE(G2), SECOND(G2))
I2:I4	I2	=ISNUMBER(G2)
J2:J4	J2	=LEN(G2)

 

[rfletcher35]

Everything in the PC said Eblish UK except for Region Format which was English US

 

[MARK858]

Everything in the PC said Eblish UK except for Region Format which was English US

That will cause it

 

[rfletcher35]

Thank you so much I believe that has work, never thought to look in Windows Region Settings!

 

[MARK858]

You're welcome