Rabi Gurung on Instagram: "How to Generate Random Time in Excel - Excel Tips and Tricks Learn how to generate random time in Excel. To generate a random time in Excel, you can use the RANDBETWEEN function along with some formatting to represent it as a time. Here's a simple formula to create random times: =TEXT(RANDBETWEEN(0, 1439)/1440, "hh:mm AM/PM") This formula generates a random time in the "hh AM/PM" format. The RANDBETWEEN(0, 1439) function produces a random integer between 0 and 1439, re