Function to randomly output date/time between to fixed date/times

[160998]

Hi there.

I'm trying to output a list of random date/times (yyyy-mm-dd hh:mm:ss) within a fixed interval.

I've tried with this formula:
=TEXT(RAND()*("2018-07-01 22:00:00"-"2018-06-04 00:00:00")+"2018-06-04 00:00:00";"yyyy-mm-dd hh:mm:ss")

But the output is not entirely as I wish:
E.g. yyyy-06-23 hh:47:15

What do I need to do in order to get the 'yyyy' and 'hh' to work?

Thanks in advance

[Special-K]

Looks like your regional settings aren't set to yyyy or hh

Check your regional settings (Locale)

[160998]

Of course. Thanks, K