Wrong minutes in date format

[jvitantonio]

Hi, can anyone tell me why the formula

=date('40813,740127315', 'DD/MM/YYYY HH:MI:SS')

throughs a wrong amount of minutes. It's like a letter i instead of a number...

Thanks.

[m_woolf · Accepted solution]

Try:   HH:MM:SS

[stephencredmond]

Hi,

You need to use lower case for time:

hh:mm:ss

Regards,

Stephen

[jvitantonio]

Thanks. That's correct. I got confused with Oracle sintax.