 |
 |
Idle Banter For non SV and non bike related chat (and the odd bit of humour - but if any post isn't suitable it'll get deleted real quick). There's also a "U" rating so please respect this. Newbies can also say "hello" here too. |
 |
|
|
Thread Tools |
16-05-12, 08:30 AM
|
#1 |
|
Member
Mega Poster
Join Date: Jul 2003
Location: In the shadows to the left
Posts: 7,700
|
Excel fiends...a question
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 |
|
|
|
16-05-12, 09:30 AM
|
#2 |
|
Guest
Posts: n/a
|
Re: Excel fiends...a question
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. |
|
|
|
16-05-12, 11:14 AM
|
#3 | |
|
Member
Mega Poster
Join Date: Jun 2005
Location: High Wycombe, where the chair factories used to be
Posts: 1,479
|
Re: Excel fiends...a question
Quote:
Why?
__________________
We are the Goon Squad and we're coming to town, BEEP BEEP! |
|
|
|
|
|
16-05-12, 12:43 PM
|
#4 |
|
Member
Mega Poster
Join Date: Jan 2008
Location: North West
Posts: 3,124
|
Re: Excel fiends...a question
he's writing a self completing time sheet algorithm.
|
|
|
|
|
16-05-12, 03:08 PM
|
#5 | |
|
Member
Mega Poster
Join Date: Apr 2010
Location: Newcastle upon Tyne, Just south of salad dodging country
Posts: 7,750
|
Re: Excel fiends...a question
Quote:
 if you crack it send me a copy
__________________
RIP Reeder 20/07/1988 - 21/03/2012. Always missed squire!!! Every year we meet old friends, gain some new ones, lose old ones and you always remember them all. “Live as if you were to die tomorrow. Learn as if you were to live forever.” Mahatma Gandhi |
|
|
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel question | Viney | Idle Banter | 4 | 05-03-12 11:29 AM |
| OK Windoze guru's (Excel Question) | timwilky | Idle Banter | 7 | 23-10-07 11:57 AM |
| Excel Question | Tris | Idle Banter | 4 | 04-04-07 11:42 AM |
| Quick excel question if some1 can help | Jimmy2Feet | Idle Banter | 4 | 21-11-06 03:27 PM |
| Excel question | nickj | Idle Banter | 3 | 04-09-06 12:35 PM |
