Ktl-icon-tai-lieu

excel random data

Được đăng lên bởi Nguyễn Tân Quý
Số trang: 4 trang   |   Lượt xem: 646 lần   |   Lượt tải: 0 lần
USING +RANDBETWEEN()
Random date
Random time
Random date between
Random time between
jan 1, 2000 - jun 28, 2013
08:00:00 - 17:00:00
Aug 30, 2005
11:05:00
Jan 1, 2001
13:36:12
Mar 21, 2006
15:26:56
Jun 18, 2008
10:01:21
Oct 25, 2008
16:01:21
Sep 19, 2011
09:24:29
Jan 20, 2002
12:58:36
May 29, 2013
14:04:08
Mar 22, 2000
11:53:40
Sep 26, 2000
15:06:46
Apr 30, 2008
08:34:31
Nov 22, 2003
08:27:10
Sep 13, 2012
13:24:23
Mar 19, 2010
15:43:47
Jul 20, 2005
16:42:06
Aug 22, 2008
14:17:31
Oct 8, 2001
11:16:31
Jan 28, 2002
13:13:52
Sep 12, 2008
14:12:46
Dec 27, 2009
13:31:35
Nov 23, 2002
12:28:39
Oct 20, 2004
12:44:21

Random date + time

Nov 13, 2006
Apr 24, 2003
Feb 11, 2003
Oct 31, 2000
Jan 14, 2000
Mar 11, 2003
Jul 27, 2012
Jun 16, 2012
May 8, 2007
Mar 28, 2011
May 3, 2013
Jan 25, 2008
May 24, 2008
Jun 20, 2000
Jun 18, 2010
Jan 18, 2011
Feb 3, 2010
Jun 19, 2009
Mar 20, 2000
Oct 22, 2011
Aug 19, 2006
Nov 18, 2011

09:10:48
14:40:42
12:15:33
11:10:45
14:07:26
10:01:29
15:47:57
11:43:26
08:49:12
12:38:27
10:12:17
16:28:51
15:17:25
16:11:08
11:38:59
13:55:03
09:40:28
14:56:41
16:24:06
14:08:18
16:44:50
14:54:32

Random date
Random date between
jan 1, 2000 - jun 28, 2013
May 19, 2012
Oct 21, 2012
Jan 11, 2007
Feb 2, 2007
Apr 18, 2013
Feb 5, 2003
Jun 16, 2001
Jul 5, 2005
Sep 25, 2008
Jul 18, 2003
Jul 14, 2011
Apr 27, 2010
Sep 29, 2004
May 24, 2001
Jan 25, 2009
Nov 15, 2000
Oct 8, 2000
Jul 20, 2006
May 28, 2004
May 29, 2010
Jun 17, 2008
Aug 22, 2005

USING +RAND()
Random time
Random time between
08:00:00 - 17:00:00
16:58:01
10:42:41
13:13:33
12:00:37
09:37:23
13:23:16
14:58:50
13:18:35
14:32:48
09:25:39
12:36:27
08:31:03
08:40:43
15:18:20
09:15:09
16:27:21
11:11:01
13:54:40
13:30:02
14:07:33
11:20:56
14:15:53

ND()
Random date + time

Mar 19, 2009
Sep 28, 2006
Nov 16, 2008
Jun 19, 2004
Sep 8, 2004
Nov 25, 2010
Apr 18, 2004
Mar 10, 2013
Oct 29, 2005
Nov 4, 2002
Jul 1, 2001
Aug 19, 2001
Aug 4, 2007
Mar 10, 2004
Dec 18, 2011
Sep 29, 2008
Nov 8, 2012
Mar 7, 2008
Jul 26, 2012
May 2, 2001
Aug 6, 2007
Jul 8, 2007

06:24:35
21:32:16
16:50:06
01:33:23
19:07:40
21:34:15
20:34:31
22:15:29
21:47:27
14:31:30
08:26:40
04:10:52
05:53:19
23:10:07
17:15:16
05:29:20
07:49:08
02:05:39
03:20:18
18:24:24
20:38:50
01:52:59

June
June
June
June
June
June
June

Date
1, 2013
1, 2013
1, 2013
1, 2013
1, 2013
1, 2013
1, 2013

Time
11:22:05
11:09:17
10:34:25
8:54:22
8:37:48
7:43:39
7:07:55

Combined
June 1, 2013 11:22:05
June 1, 2013 11:09:17
June 1, 2013 10:34:25
June 1, 2013 08:54:22
June 1, 20...
USING +RANDBETWEEN()
Random date Random time Random date + time
Aug 30, 2005 11:05:00 Nov 13, 2006 09:10:48
Jan 1, 2001 13:36:12 Apr 24, 2003 14:40:42
Mar 21, 2006 15:26:56 Feb 11, 2003 12:15:33
Jun 18, 2008 10:01:21 Oct 31, 2000 11:10:45
Oct 25, 2008 16:01:21 Jan 14, 2000 14:07:26
Sep 19, 2011 09:24:29 Mar 11, 2003 10:01:29
Jan 20, 2002 12:58:36 Jul 27, 2012 15:47:57
May 29, 2013 14:04:08 Jun 16, 2012 11:43:26
Mar 22, 2000 11:53:40 May 8, 2007 08:49:12
Sep 26, 2000 15:06:46 Mar 28, 2011 12:38:27
Apr 30, 2008 08:34:31 May 3, 2013 10:12:17
Nov 22, 2003 08:27:10 Jan 25, 2008 16:28:51
Sep 13, 2012 13:24:23 May 24, 2008 15:17:25
Mar 19, 2010 15:43:47 Jun 20, 2000 16:11:08
Jul 20, 2005 16:42:06 Jun 18, 2010 11:38:59
Aug 22, 2008 14:17:31 Jan 18, 2011 13:55:03
Oct 8, 2001 11:16:31 Feb 3, 2010 09:40:28
Jan 28, 2002 13:13:52 Jun 19, 2009 14:56:41
Sep 12, 2008 14:12:46 Mar 20, 2000 16:24:06
Dec 27, 2009 13:31:35 Oct 22, 2011 14:08:18
Nov 23, 2002 12:28:39 Aug 19, 2006 16:44:50
Oct 20, 2004 12:44:21 Nov 18, 2011 14:54:32
Random date between
jan 1, 2000 - jun 28, 2013
Random time between
08:00:00 - 17:00:00
excel random data - Trang 2
excel random data - Người đăng: Nguyễn Tân Quý
5 Tài liệu rất hay! Được đăng lên bởi - 1 giờ trước Đúng là cái mình đang tìm. Rất hay và bổ ích. Cảm ơn bạn!
4 Vietnamese
excel random data 9 10 510