In excel,how do you generate random times so that they only contain even-numbered hours (e.g., 2:46pm, 4:43pm, 6:32pm, etc.) between 10 am and 8pm?

Vote count:

0

In excel,how do you generate random times so that they only contain even-numbered hours (e.g., 2:46pm, 4:43pm, 6:32pm, etc.) between 10 am and 8pm?

asked 1 min ago

andrew c

1

In excel,how do you generate random times so that they only contain even-numbered hours (e.g., 2:46pm, 4:43pm, 6:32pm, etc.) between 10 am and 8pm?