Excel fiends...a question

[Viney]

Ok, i have a range of dates and times expressed as say

10/05/12 08:23:14

I wish to randomly add anything between 25 minutes to 1 hour 10 minutes to those times.

I know that there is a random function, but i can not get it to work with the format.

Help.

Thank you

[StewartR]

1 = 1 day in Excel so a minute is 1 divided by 24 (hours) divided by 60 (minutes), or 1/1440.

So if your original date/time is in A1 your formula would be "=A1+(RANDBETWEEN(25,70)/1440)"

Hope this helps.

[Sir Trev]

I wish to randomly add anything between 25 minutes to 1 hour 10 minutes to those times.



It's no good. I have to ask.

Why?

[flymo]

he's writing a self completing time sheet algorithm. ;-)

[andrewsmith]

he's writing a self completing time sheet algorithm. ;-)

:lol:

if you crack it send me a copy