Hi All, I want to put random time, between two time ranges.
in column D the time is starting time and then in the next column i.e. E random numbers I want to add these numbers in the starting time to make ending time in column F
Hi All, I want to put random time, between two time ranges.
in column D the time is starting time and then in the next column i.e. E random numbers I want to add these numbers in the starting time to make ending time in column F
I am not sure but this should help, i think you should give the random in time format HH:mm:SS.
THANKS FOR YOUR REPLY
if column D is AM and column F is PM then how do i get the result please see the picture
i dont want as 19:30 but to see 7:30 PM
Check this , you may also find other methods from other forum members
Okay dear thanks i got it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks