- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 6:16 pm
You last visited
June 5, 2026, 12:00 pm
All times shown are
Eastern Time (GMT-5:00)
Decimal Days to Date 0
Published:
Been working on a Decimal Days to Date / Time and back to Decimal Days functions in Excel.
The dating is based on the Gregorian Calendar System.
I'll have more posts about this later.
In the meantime, here's a few tables we worked out running from negative to positive.
|
Date |
||||
|
Decimal Days |
1 Based Month & Day |
0 Based Month & Day |
||
|
+ Unsigned |
+ Signed |
+ Unsigned |
+ Signed |
|
|
-3.00 |
-0001-12-29 |
-0001-12-29 |
-0001-11-28 |
-0001-11-28 |
|
-2.00 |
-0001-12-30 |
-0001-12-30 |
-0001-11-29 |
-0001-11-29 |
|
-1.00 |
-0001-12-31 |
-0001-12-31 |
-0001-11-30 |
-0001-11-30 |
|
0.00 |
0000-01-01 |
+0000-01-01 |
0000-00-00 |
+0000-00-00 |
|
1.00 |
0000-01-02 |
+0000-01-02 |
0000-00-01 |
+0000-00-01 |
|
2.00 |
0000-01-03 |
+0000-01-03 |
0000-00-02 |
+0000-00-02 |
|
3.00 |
0000-01-04 |
+0000-01-04 |
0000-00-03 |
+0000-00-03 |
|
Date Hour Minute |
||||
|
Decimal Days |
1 Based Month & Day |
0 Based Month & Day |
||
|
+ Unsigned |
+ Signed |
+ Unsigned |
+ Signed |
|
|
-3.00 |
-0001-12-29 00:00 |
-0001-12-29 00:00 |
-0001-11-28 00:00 |
-0001-11-28 00:00 |
|
-2.75 |
-0001-12-29 06:00 |
-0001-12-29 06:00 |
-0001-11-28 06:00 |
-0001-11-28 06:00 |
|
-2.50 |
-0001-12-29 12:00 |
-0001-12-29 12:00 |
-0001-11-28 12:00 |
-0001-11-28 12:00 |
|
-2.25 |
-0001-12-29 18:00 |
-0001-12-29 18:00 |
-0001-11-28 18:00 |
-0001-11-28 18:00 |
|
-2.00 |
-0001-12-30 00:00 |
-0001-12-30 00:00 |
-0001-11-29 00:00 |
-0001-11-29 00:00 |
|
-1.75 |
-0001-12-30 06:00 |
-0001-12-30 06:00 |
-0001-11-29 06:00 |
-0001-11-29 06:00 |
|
-1.50 |
-0001-12-30 12:00 |
-0001-12-30 12:00 |
-0001-11-29 12:00 |
-0001-11-29 12:00 |
|
-1.25 |
-0001-12-30 18:00 |
-0001-12-30 18:00 |
-0001-11-29 18:00 |
-0001-11-29 18:00 |
|
-1.00 |
-0001-12-31 00:00 |
-0001-12-31 00:00 |
-0001-11-30 00:00 |
-0001-11-30 00:00 |
|
-0.75 |
-0001-12-31 06:00 |
-0001-12-31 06:00 |
-0001-11-30 06:00 |
-0001-11-30 06:00 |
|
-0.50 |
-0001-12-31 12:00 |
-0001-12-31 12:00 |
-0001-11-30 12:00 |
-0001-11-30 12:00 |
|
-0.25 |
-0001-12-31 18:00 |
-0001-12-31 18:00 |
-0001-11-30 18:00 |
-0001-11-30 18:00 |
|
0.00 |
0000-01-01 00:00 |
+0000-01-01 00:00 |
0000-00-00 00:00 |
+0000-00-00 00:00 |
|
0.25 |
0000-01-01 06:00 |
+0000-01-01 06:00 |
0000-00-00 06:00 |
+0000-00-00 06:00 |
|
0.50 |
0000-01-01 12:00 |
+0000-01-01 12:00 |
0000-00-00 12:00 |
+0000-00-00 12:00 |
|
0.75 |
0000-01-01 18:00 |
+0000-01-01 18:00 |
0000-00-00 18:00 |
+0000-00-00 18:00 |
|
1.00 |
0000-01-02 00:00 |
+0000-01-02 00:00 |
0000-00-01 00:00 |
+0000-00-01 00:00 |
|
1.25 |
0000-01-02 06:00 |
+0000-01-02 06:00 |
0000-00-01 06:00 |
+0000-00-01 06:00 |
|
1.50 |
0000-01-02 12:00 |
+0000-01-02 12:00 |
0000-00-01 12:00 |
+0000-00-01 12:00 |
|
1.75 |
0000-01-02 18:00 |
+0000-01-02 18:00 |
0000-00-01 18:00 |
+0000-00-01 18:00 |
|
2.00 |
0000-01-03 00:00 |
+0000-01-03 00:00 |
0000-00-02 00:00 |
+0000-00-02 00:00 |
|
2.25 |
0000-01-03 06:00 |
+0000-01-03 06:00 |
0000-00-02 06:00 |
+0000-00-02 06:00 |
|
2.50 |
0000-01-03 12:00 |
+0000-01-03 12:00 |
0000-00-02 12:00 |
+0000-00-02 12:00 |
|
2.75 |
0000-01-03 18:00 |
+0000-01-03 18:00 |
0000-00-02 18:00 |
+0000-00-02 18:00 |
|
3.00 |
0000-01-04 00:00 |
+0000-01-04 00:00 |
0000-00-03 00:00 |
+0000-00-03 00:00 |
|
Date Time |
||||
|
Decimal Days |
1 Based Month & Day |
0 Based Month & Day |
||
|
+ Unsigned |
+ Signed |
+ Unsigned |
+ Signed |
|
|
-1.20 |
-0001-12-30 19:12:00.0 |
-0001-12-30 19:12:00.0 |
-0001-11-29 19:12:00.0 |
-0001-11-29 19:12:00.0 |
|
-1.00 |
-0001-12-31 00:00:00.0 |
-0001-12-31 00:00:00.0 |
-0001-11-30 00:00:00.0 |
-0001-11-30 00:00:00.0 |
|
-0.98 |
-0001-12-31 00:28:48.0 |
-0001-12-31 00:28:48.0 |
-0001-11-30 00:28:48.0 |
-0001-11-30 00:28:48.0 |
|
-0.96 |
-0001-12-31 00:57:36.0 |
-0001-12-31 00:57:36.0 |
-0001-11-30 00:57:36.0 |
-0001-11-30 00:57:36.0 |
|
-0.94 |
-0001-12-31 01:26:24.0 |
-0001-12-31 01:26:24.0 |
-0001-11-30 01:26:24.0 |
-0001-11-30 01:26:24.0 |
|
-0.92 |
-0001-12-31 01:55:12.0 |
-0001-12-31 01:55:12.0 |
-0001-11-30 01:55:12.0 |
-0001-11-30 01:55:12.0 |
|
-0.90 |
-0001-12-31 02:24:00.0 |
-0001-12-31 02:24:00.0 |
-0001-11-30 02:24:00.0 |
-0001-11-30 02:24:00.0 |
|
-0.88 |
-0001-12-31 02:52:48.0 |
-0001-12-31 02:52:48.0 |
-0001-11-30 02:52:48.0 |
-0001-11-30 02:52:48.0 |
|
-0.86 |
-0001-12-31 03:21:36.0 |
-0001-12-31 03:21:36.0 |
-0001-11-30 03:21:36.0 |
-0001-11-30 03:21:36.0 |
|
-0.84 |
-0001-12-31 03:50:24.0 |
-0001-12-31 03:50:24.0 |
-0001-11-30 03:50:24.0 |
-0001-11-30 03:50:24.0 |
|
-0.82 |
-0001-12-31 04:19:12.0 |
-0001-12-31 04:19:12.0 |
-0001-11-30 04:19:12.0 |
-0001-11-30 04:19:12.0 |
|
-0.80 |
-0001-12-31 04:48:00.0 |
-0001-12-31 04:48:00.0 |
-0001-11-30 04:48:00.0 |
-0001-11-30 04:48:00.0 |
|
-0.78 |
-0001-12-31 05:16:48.0 |
-0001-12-31 05:16:48.0 |
-0001-11-30 05:16:48.0 |
-0001-11-30 05:16:48.0 |
|
-0.76 |
-0001-12-31 05:45:36.0 |
-0001-12-31 05:45:36.0 |
-0001-11-30 05:45:36.0 |
-0001-11-30 05:45:36.0 |
|
-0.74 |
-0001-12-31 06:14:24.0 |
-0001-12-31 06:14:24.0 |
-0001-11-30 06:14:24.0 |
-0001-11-30 06:14:24.0 |
|
-0.72 |
-0001-12-31 06:43:12.0 |
-0001-12-31 06:43:12.0 |
-0001-11-30 06:43:12.0 |
-0001-11-30 06:43:12.0 |
|
-0.70 |
-0001-12-31 07:12:00.0 |
-0001-12-31 07:12:00.0 |
-0001-11-30 07:12:00.0 |
-0001-11-30 07:12:00.0 |
|
-0.68 |
-0001-12-31 07:40:48.0 |
-0001-12-31 07:40:48.0 |
-0001-11-30 07:40:48.0 |
-0001-11-30 07:40:48.0 |
|
-0.66 |
-0001-12-31 08:09:36.0 |
-0001-12-31 08:09:36.0 |
-0001-11-30 08:09:36.0 |
-0001-11-30 08:09:36.0 |
|
-0.64 |
-0001-12-31 08:38:24.0 |
-0001-12-31 08:38:24.0 |
-0001-11-30 08:38:24.0 |
-0001-11-30 08:38:24.0 |
|
-0.62 |
-0001-12-31 09:07:12.0 |
-0001-12-31 09:07:12.0 |
-0001-11-30 09:07:12.0 |
-0001-11-30 09:07:12.0 |
|
-0.60 |
-0001-12-31 09:36:00.0 |
-0001-12-31 09:36:00.0 |
-0001-11-30 09:36:00.0 |
-0001-11-30 09:36:00.0 |
|
-0.58 |
-0001-12-31 10:04:48.0 |
-0001-12-31 10:04:48.0 |
-0001-11-30 10:04:48.0 |
-0001-11-30 10:04:48.0 |
|
-0.56 |
-0001-12-31 10:33:36.0 |
-0001-12-31 10:33:36.0 |
-0001-11-30 10:33:36.0 |
-0001-11-30 10:33:36.0 |
|
-0.54 |
-0001-12-31 11:02:24.0 |
-0001-12-31 11:02:24.0 |
-0001-11-30 11:02:24.0 |
-0001-11-30 11:02:24.0 |
|
-0.52 |
-0001-12-31 11:31:12.0 |
-0001-12-31 11:31:12.0 |
-0001-11-30 11:31:12.0 |
-0001-11-30 11:31:12.0 |
|
-0.50 |
-0001-12-31 12:00:00.0 |
-0001-12-31 12:00:00.0 |
-0001-11-30 12:00:00.0 |
-0001-11-30 12:00:00.0 |
|
-0.48 |
-0001-12-31 12:28:48.0 |
-0001-12-31 12:28:48.0 |
-0001-11-30 12:28:48.0 |
-0001-11-30 12:28:48.0 |
|
-0.46 |
-0001-12-31 12:57:36.0 |
-0001-12-31 12:57:36.0 |
-0001-11-30 12:57:36.0 |
-0001-11-30 12:57:36.0 |
|
-0.44 |
-0001-12-31 13:26:24.0 |
-0001-12-31 13:26:24.0 |
-0001-11-30 13:26:24.0 |
-0001-11-30 13:26:24.0 |
|
-0.42 |
-0001-12-31 13:55:12.0 |
-0001-12-31 13:55:12.0 |
-0001-11-30 13:55:12.0 |
-0001-11-30 13:55:12.0 |
|
-0.40 |
-0001-12-31 14:24:00.0 |
-0001-12-31 14:24:00.0 |
-0001-11-30 14:24:00.0 |
-0001-11-30 14:24:00.0 |
|
-0.38 |
-0001-12-31 14:52:48.0 |
-0001-12-31 14:52:48.0 |
-0001-11-30 14:52:48.0 |
-0001-11-30 14:52:48.0 |
|
-0.36 |
-0001-12-31 15:21:36.0 |
-0001-12-31 15:21:36.0 |
-0001-11-30 15:21:36.0 |
-0001-11-30 15:21:36.0 |
|
-0.34 |
-0001-12-31 15:50:24.0 |
-0001-12-31 15:50:24.0 |
-0001-11-30 15:50:24.0 |
-0001-11-30 15:50:24.0 |
|
-0.32 |
-0001-12-31 16:19:12.0 |
-0001-12-31 16:19:12.0 |
-0001-11-30 16:19:12.0 |
-0001-11-30 16:19:12.0 |
|
-0.30 |
-0001-12-31 16:48:00.0 |
-0001-12-31 16:48:00.0 |
-0001-11-30 16:48:00.0 |
-0001-11-30 16:48:00.0 |
|
-0.28 |
-0001-12-31 17:16:48.0 |
-0001-12-31 17:16:48.0 |
-0001-11-30 17:16:48.0 |
-0001-11-30 17:16:48.0 |
|
-0.26 |
-0001-12-31 17:45:36.0 |
-0001-12-31 17:45:36.0 |
-0001-11-30 17:45:36.0 |
-0001-11-30 17:45:36.0 |
|
-0.24 |
-0001-12-31 18:14:24.0 |
-0001-12-31 18:14:24.0 |
-0001-11-30 18:14:24.0 |
-0001-11-30 18:14:24.0 |
|
-0.22 |
-0001-12-31 18:43:12.0 |
-0001-12-31 18:43:12.0 |
-0001-11-30 18:43:12.0 |
-0001-11-30 18:43:12.0 |
|
-0.20 |
-0001-12-31 19:12:00.0 |
-0001-12-31 19:12:00.0 |
-0001-11-30 19:12:00.0 |
-0001-11-30 19:12:00.0 |
|
-0.18 |
-0001-12-31 19:40:48.0 |
-0001-12-31 19:40:48.0 |
-0001-11-30 19:40:48.0 |
-0001-11-30 19:40:48.0 |
|
-0.16 |
-0001-12-31 20:09:36.0 |
-0001-12-31 20:09:36.0 |
-0001-11-30 20:09:36.0 |
-0001-11-30 20:09:36.0 |
|
-0.14 |
-0001-12-31 20:38:24.0 |
-0001-12-31 20:38:24.0 |
-0001-11-30 20:38:24.0 |
-0001-11-30 20:38:24.0 |
|
-0.12 |
-0001-12-31 21:07:12.0 |
-0001-12-31 21:07:12.0 |
-0001-11-30 21:07:12.0 |
-0001-11-30 21:07:12.0 |
|
-0.10 |
-0001-12-31 21:36:00.0 |
-0001-12-31 21:36:00.0 |
-0001-11-30 21:36:00.0 |
-0001-11-30 21:36:00.0 |
|
-0.08 |
-0001-12-31 22:04:48.0 |
-0001-12-31 22:04:48.0 |
-0001-11-30 22:04:48.0 |
-0001-11-30 22:04:48.0 |
|
-0.06 |
-0001-12-31 22:33:36.0 |
-0001-12-31 22:33:36.0 |
-0001-11-30 22:33:36.0 |
-0001-11-30 22:33:36.0 |
|
-0.04 |
-0001-12-31 23:02:24.0 |
-0001-12-31 23:02:24.0 |
-0001-11-30 23:02:24.0 |
-0001-11-30 23:02:24.0 |
|
-0.02 |
-0001-12-31 23:31:12.0 |
-0001-12-31 23:31:12.0 |
-0001-11-30 23:31:12.0 |
-0001-11-30 23:31:12.0 |
|
0.00 |
0000-01-01 00:00:00.0 |
+0000-01-01 00:00:00.0 |
0000-00-00 00:00:00.0 |
+0000-00-00 00:00:00.0 |
|
0.02 |
0000-01-01 00:28:48.0 |
+0000-01-01 00:28:48.0 |
0000-00-00 00:28:48.0 |
+0000-00-00 00:28:48.0 |
|
0.04 |
0000-01-01 00:57:36.0 |
+0000-01-01 00:57:36.0 |
0000-00-00 00:57:36.0 |
+0000-00-00 00:57:36.0 |
|
0.06 |
0000-01-01 01:26:24.0 |
+0000-01-01 01:26:24.0 |
0000-00-00 01:26:24.0 |
+0000-00-00 01:26:24.0 |
|
0.08 |
0000-01-01 01:55:12.0 |
+0000-01-01 01:55:12.0 |
0000-00-00 01:55:12.0 |
+0000-00-00 01:55:12.0 |
|
0.10 |
0000-01-01 02:24:00.0 |
+0000-01-01 02:24:00.0 |
0000-00-00 02:24:00.0 |
+0000-00-00 02:24:00.0 |
|
0.12 |
0000-01-01 02:52:48.0 |
+0000-01-01 02:52:48.0 |
0000-00-00 02:52:48.0 |
+0000-00-00 02:52:48.0 |
|
0.14 |
0000-01-01 03:21:36.0 |
+0000-01-01 03:21:36.0 |
0000-00-00 03:21:36.0 |
+0000-00-00 03:21:36.0 |
|
0.16 |
0000-01-01 03:50:24.0 |
+0000-01-01 03:50:24.0 |
0000-00-00 03:50:24.0 |
+0000-00-00 03:50:24.0 |
|
0.18 |
0000-01-01 04:19:12.0 |
+0000-01-01 04:19:12.0 |
0000-00-00 04:19:12.0 |
+0000-00-00 04:19:12.0 |
|
0.20 |
0000-01-01 04:48:00.0 |
+0000-01-01 04:48:00.0 |
0000-00-00 04:48:00.0 |
+0000-00-00 04:48:00.0 |
|
0.22 |
0000-01-01 05:16:48.0 |
+0000-01-01 05:16:48.0 |
0000-00-00 05:16:48.0 |
+0000-00-00 05:16:48.0 |
|
0.24 |
0000-01-01 05:45:36.0 |
+0000-01-01 05:45:36.0 |
0000-00-00 05:45:36.0 |
+0000-00-00 05:45:36.0 |
|
0.26 |
0000-01-01 06:14:24.0 |
+0000-01-01 06:14:24.0 |
0000-00-00 06:14:24.0 |
+0000-00-00 06:14:24.0 |
|
0.28 |
0000-01-01 06:43:12.0 |
+0000-01-01 06:43:12.0 |
0000-00-00 06:43:12.0 |
+0000-00-00 06:43:12.0 |
|
0.30 |
0000-01-01 07:12:00.0 |
+0000-01-01 07:12:00.0 |
0000-00-00 07:12:00.0 |
+0000-00-00 07:12:00.0 |
|
0.32 |
0000-01-01 07:40:48.0 |
+0000-01-01 07:40:48.0 |
0000-00-00 07:40:48.0 |
+0000-00-00 07:40:48.0 |
|
0.34 |
0000-01-01 08:09:36.0 |
+0000-01-01 08:09:36.0 |
0000-00-00 08:09:36.0 |
+0000-00-00 08:09:36.0 |
|
0.36 |
0000-01-01 08:38:24.0 |
+0000-01-01 08:38:24.0 |
0000-00-00 08:38:24.0 |
+0000-00-00 08:38:24.0 |
|
0.38 |
0000-01-01 09:07:12.0 |
+0000-01-01 09:07:12.0 |
0000-00-00 09:07:12.0 |
+0000-00-00 09:07:12.0 |
|
0.40 |
0000-01-01 09:36:00.0 |
+0000-01-01 09:36:00.0 |
0000-00-00 09:36:00.0 |
+0000-00-00 09:36:00.0 |
|
0.42 |
0000-01-01 10:04:48.0 |
+0000-01-01 10:04:48.0 |
0000-00-00 10:04:48.0 |
+0000-00-00 10:04:48.0 |
|
0.44 |
0000-01-01 10:33:36.0 |
+0000-01-01 10:33:36.0 |
0000-00-00 10:33:36.0 |
+0000-00-00 10:33:36.0 |
|
0.46 |
0000-01-01 11:02:24.0 |
+0000-01-01 11:02:24.0 |
0000-00-00 11:02:24.0 |
+0000-00-00 11:02:24.0 |
|
0.48 |
0000-01-01 11:31:12.0 |
+0000-01-01 11:31:12.0 |
0000-00-00 11:31:12.0 |
+0000-00-00 11:31:12.0 |
|
0.50 |
0000-01-01 12:00:00.0 |
+0000-01-01 12:00:00.0 |
0000-00-00 12:00:00.0 |
+0000-00-00 12:00:00.0 |
|
0.52 |
0000-01-01 12:28:48.0 |
+0000-01-01 12:28:48.0 |
0000-00-00 12:28:48.0 |
+0000-00-00 12:28:48.0 |
|
0.54 |
0000-01-01 12:57:36.0 |
+0000-01-01 12:57:36.0 |
0000-00-00 12:57:36.0 |
+0000-00-00 12:57:36.0 |
|
0.56 |
0000-01-01 13:26:24.0 |
+0000-01-01 13:26:24.0 |
0000-00-00 13:26:24.0 |
+0000-00-00 13:26:24.0 |
|
0.58 |
0000-01-01 13:55:12.0 |
+0000-01-01 13:55:12.0 |
0000-00-00 13:55:12.0 |
+0000-00-00 13:55:12.0 |
|
0.60 |
0000-01-01 14:24:00.0 |
+0000-01-01 14:24:00.0 |
0000-00-00 14:24:00.0 |
+0000-00-00 14:24:00.0 |
|
0.62 |
0000-01-01 14:52:48.0 |
+0000-01-01 14:52:48.0 |
0000-00-00 14:52:48.0 |
+0000-00-00 14:52:48.0 |
|
0.64 |
0000-01-01 15:21:36.0 |
+0000-01-01 15:21:36.0 |
0000-00-00 15:21:36.0 |
+0000-00-00 15:21:36.0 |
|
0.66 |
0000-01-01 15:50:24.0 |
+0000-01-01 15:50:24.0 |
0000-00-00 15:50:24.0 |
+0000-00-00 15:50:24.0 |
|
0.68 |
0000-01-01 16:19:12.0 |
+0000-01-01 16:19:12.0 |
0000-00-00 16:19:12.0 |
+0000-00-00 16:19:12.0 |
|
0.70 |
0000-01-01 16:48:00.0 |
+0000-01-01 16:48:00.0 |
0000-00-00 16:48:00.0 |
+0000-00-00 16:48:00.0 |
|
0.72 |
0000-01-01 17:16:48.0 |
+0000-01-01 17:16:48.0 |
0000-00-00 17:16:48.0 |
+0000-00-00 17:16:48.0 |
|
0.74 |
0000-01-01 17:45:36.0 |
+0000-01-01 17:45:36.0 |
0000-00-00 17:45:36.0 |
+0000-00-00 17:45:36.0 |
|
0.76 |
0000-01-01 18:14:24.0 |
+0000-01-01 18:14:24.0 |
0000-00-00 18:14:24.0 |
+0000-00-00 18:14:24.0 |
|
0.78 |
0000-01-01 18:43:12.0 |
+0000-01-01 18:43:12.0 |
0000-00-00 18:43:12.0 |
+0000-00-00 18:43:12.0 |
|
0.80 |
0000-01-01 19:12:00.0 |
+0000-01-01 19:12:00.0 |
0000-00-00 19:12:00.0 |
+0000-00-00 19:12:00.0 |
|
0.82 |
0000-01-01 19:40:48.0 |
+0000-01-01 19:40:48.0 |
0000-00-00 19:40:48.0 |
+0000-00-00 19:40:48.0 |
|
0.84 |
0000-01-01 20:09:36.0 |
+0000-01-01 20:09:36.0 |
0000-00-00 20:09:36.0 |
+0000-00-00 20:09:36.0 |
|
0.86 |
0000-01-01 20:38:24.0 |
+0000-01-01 20:38:24.0 |
0000-00-00 20:38:24.0 |
+0000-00-00 20:38:24.0 |
|
0.88 |
0000-01-01 21:07:12.0 |
+0000-01-01 21:07:12.0 |
0000-00-00 21:07:12.0 |
+0000-00-00 21:07:12.0 |
|
0.90 |
0000-01-01 21:36:00.0 |
+0000-01-01 21:36:00.0 |
0000-00-00 21:36:00.0 |
+0000-00-00 21:36:00.0 |
|
0.92 |
0000-01-01 22:04:48.0 |
+0000-01-01 22:04:48.0 |
0000-00-00 22:04:48.0 |
+0000-00-00 22:04:48.0 |
|
0.94 |
0000-01-01 22:33:36.0 |
+0000-01-01 22:33:36.0 |
0000-00-00 22:33:36.0 |
+0000-00-00 22:33:36.0 |
|
0.96 |
0000-01-01 23:02:24.0 |
+0000-01-01 23:02:24.0 |
0000-00-00 23:02:24.0 |
+0000-00-00 23:02:24.0 |
|
0.98 |
0000-01-01 23:31:12.0 |
+0000-01-01 23:31:12.0 |
0000-00-00 23:31:12.0 |
+0000-00-00 23:31:12.0 |
|
1.00 |
0000-01-02 00:00:00.0 |
+0000-01-02 00:00:00.0 |
0000-00-01 00:00:00.0 |
+0000-00-01 00:00:00.0 |
|
1.20 |
0000-01-02 04:48:00.0 |
+0000-01-02 04:48:00.0 |
0000-00-01 04:48:00.0 |
+0000-00-01 04:48:00.0 |
|
Random Decimal Days to Date Time |
||||
|
Decimal Days |
1 Based Month & Day |
0 Based Month & Day |
||
|
+ Unsigned |
+ Signed |
+ Unsigned |
+ Signed |
|
|
722916.078457 |
1979-04-12 01:52:58.7 |
+1979-04-12 01:52:58.7 |
1979-03-11 01:52:58.7 |
+1979-03-11 01:52:58.7 |
|
-47298.607032 |
-0130-07-02 09:25:52.4 |
-0130-07-02 09:25:52.4 |
-0130-06-01 09:25:52.4 |
-0130-06-01 09:25:52.4 |
|
-553363.724819 |
-1516-12-09 06:36:15.6 |
-1516-12-09 06:36:15.6 |
-1516-11-08 06:36:15.6 |
-1516-11-08 06:36:15.6 |
|
-299157.749084 |
-0820-12-07 06:01:19.1 |
-0820-12-07 06:01:19.1 |
-0820-11-06 06:01:19.1 |
-0820-11-06 06:01:19.1 |
|
686401.790733 |
1879-04-21 18:58:39.3 |
+1879-04-21 18:58:39.3 |
1879-03-20 18:58:39.3 |
+1879-03-20 18:58:39.3 |
|
-433966.150360 |
-1189-11-03 20:23:28.9 |
-1189-11-03 20:23:28.9 |
-1189-10-02 20:23:28.9 |
-1189-10-02 20:23:28.9 |
|
665214.927037 |
1821-04-18 22:14:56.0 |
+1821-04-18 22:14:56.0 |
1821-03-17 22:14:56.0 |
+1821-03-17 22:14:56.0 |
|
-18732.989944 |
-0052-09-17 00:14:28.8 |
-0052-09-17 00:14:28.8 |
-0052-08-16 00:14:28.8 |
-0052-08-16 00:14:28.8 |
|
-342169.305007 |
-0937-03-04 16:40:47.4 |
-0937-03-04 16:40:47.4 |
-0937-02-03 16:40:47.4 |
-0937-02-03 16:40:47.4 |
|
-908613.115260 |
-2488-04-20 21:14:01.5 |
-2488-04-20 21:14:01.5 |
-2488-03-19 21:14:01.5 |
-2488-03-19 21:14:01.5 |
|
870876.022665 |
2384-05-18 00:32:38.3 |
+2384-05-18 00:32:38.3 |
2384-04-17 00:32:38.3 |
+2384-04-17 00:32:38.3 |
|
-265743.844045 |
-0728-06-01 03:44:34.5 |
-0728-06-01 03:44:34.5 |
-0728-05-00 03:44:34.5 |
-0728-05-00 03:44:34.5 |
|
-770768.839709 |
-2111-09-15 03:50:49.1 |
-2111-09-15 03:50:49.1 |
-2111-08-14 03:50:49.1 |
-2111-08-14 03:50:49.1 |
|
776475.963782 |
2125-12-01 23:07:50.8 |
+2125-12-01 23:07:50.8 |
2125-11-00 23:07:50.8 |
+2125-11-00 23:07:50.8 |
|
-696893.967557 |
-1909-12-20 00:46:43.1 |
-1909-12-20 00:46:43.1 |
-1909-11-19 00:46:43.1 |
-1909-11-19 00:46:43.1 |
|
-80105.209654 |
-0220-09-04 18:58:05.9 |
-0220-09-04 18:58:05.9 |
-0220-08-03 18:58:05.9 |
-0220-08-03 18:58:05.9 |
|
-297057.013510 |
-0814-09-07 23:40:32.7 |
-0814-09-07 23:40:32.7 |
-0814-08-06 23:40:32.7 |
-0814-08-06 23:40:32.7 |
|
-897221.040819 |
-2457-06-29 23:01:13.2 |
-2457-06-29 23:01:13.2 |
-2457-05-28 23:01:13.2 |
-2457-05-28 23:01:13.2 |
|
-193365.694099 |
-0530-08-01 07:20:29.8 |
-0530-08-01 07:20:29.8 |
-0530-07-00 07:20:29.8 |
-0530-07-00 07:20:29.8 |
|
60097.959245 |
0164-07-16 23:01:18.8 |
+0164-07-16 23:01:18.8 |
0164-06-15 23:01:18.8 |
+0164-06-15 23:01:18.8 |
|
-793032.963816 |
-2172-10-01 00:52:06.3 |
-2172-10-01 00:52:06.3 |
-2172-09-00 00:52:06.3 |
-2172-09-00 00:52:06.3 |
|
-549586.343274 |
-1505-04-13 15:45:41.1 |
-1505-04-13 15:45:41.1 |
-1505-03-12 15:45:41.1 |
-1505-03-12 15:45:41.1 |
|
-699996.486711 |
-1917-06-22 12:19:08.2 |
-1917-06-22 12:19:08.2 |
-1917-05-21 12:19:08.2 |
-1917-05-21 12:19:08.2 |
|
577445.467010 |
1580-12-28 11:12:29.7 |
+1580-12-28 11:12:29.7 |
1580-11-27 11:12:29.7 |
+1580-11-27 11:12:29.7 |
|
-238940.470354 |
-0655-10-20 12:42:41.4 |
-0655-10-20 12:42:41.4 |
-0655-09-19 12:42:41.4 |
-0655-09-19 12:42:41.4 |
|
-179685.045153 |
-0492-01-15 22:54:58.8 |
-0492-01-15 22:54:58.8 |
-0492-00-14 22:54:58.8 |
-0492-00-14 22:54:58.8 |
|
200197.687141 |
0548-02-14 16:29:29.0 |
+0548-02-14 16:29:29.0 |
0548-01-13 16:29:29.0 |
+0548-01-13 16:29:29.0 |
|
-135416.384335 |
-0371-03-29 14:46:33.5 |
-0371-03-29 14:46:33.5 |
-0371-02-28 14:46:33.5 |
-0371-02-28 14:46:33.5 |
|
-894454.438201 |
-2449-01-25 13:28:59.4 |
-2449-01-25 13:28:59.4 |
-2449-00-24 13:28:59.4 |
-2449-00-24 13:28:59.4 |
|
531867.674291 |
1456-03-15 16:10:58.7 |
+1456-03-15 16:10:58.7 |
1456-02-14 16:10:58.7 |
+1456-02-14 16:10:58.7 |
|
-862439.725772 |
-2362-09-20 06:34:53.3 |
-2362-09-20 06:34:53.3 |
-2362-08-19 06:34:53.3 |
-2362-08-19 06:34:53.3 |
|
-764736.252193 |
-2094-03-23 17:56:50.5 |
-2094-03-23 17:56:50.5 |
-2094-02-22 17:56:50.5 |
-2094-02-22 17:56:50.5 |
|
-369.038430 |
-0002-12-27 23:04:39.6 |
-0002-12-27 23:04:39.6 |
-0002-11-26 23:04:39.6 |
-0002-11-26 23:04:39.6 |
|
-785798.686694 |
-2152-07-22 07:31:09.6 |
-2152-07-22 07:31:09.6 |
-2152-06-21 07:31:09.6 |
-2152-06-21 07:31:09.6 |
|
292161.271289 |
0799-11-29 06:30:39.4 |
+0799-11-29 06:30:39.4 |
0799-10-28 06:30:39.4 |
+0799-10-28 06:30:39.4 |
|
-272100.519160 |
-0745-01-05 11:32:24.6 |
-0745-01-05 11:32:24.6 |
-0745-00-04 11:32:24.6 |
-0745-00-04 11:32:24.6 |
|
330014.527337 |
0903-07-20 12:39:21.9 |
+0903-07-20 12:39:21.9 |
0903-06-19 12:39:21.9 |
+0903-06-19 12:39:21.9 |
|
629022.633014 |
1722-03-16 15:11:32.4 |
+1722-03-16 15:11:32.4 |
1722-02-15 15:11:32.4 |
+1722-02-15 15:11:32.4 |
|
-424751.328563 |
-1163-01-25 16:06:52.2 |
-1163-01-25 16:06:52.2 |
-1163-00-24 16:06:52.2 |
-1163-00-24 16:06:52.2 |
|
-148797.769982 |
-0408-08-09 05:31:13.6 |
-0408-08-09 05:31:13.6 |
-0408-07-08 05:31:13.6 |
-0408-07-08 05:31:13.6 |
|
-628631.053271 |
-1722-11-12 22:43:17.4 |
-1722-11-12 22:43:17.4 |
-1722-10-11 22:43:17.4 |
-1722-10-11 22:43:17.4 |
|
935450.903526 |
2561-03-05 21:41:04.6 |
+2561-03-05 21:41:04.6 |
2561-02-04 21:41:04.6 |
+2561-02-04 21:41:04.6 |
|
-111425.934413 |
-0306-12-04 01:34:26.7 |
-0306-12-04 01:34:26.7 |
-0306-11-03 01:34:26.7 |
-0306-11-03 01:34:26.7 |
|
270831.198724 |
0741-07-06 04:46:09.8 |
+0741-07-06 04:46:09.8 |
0741-06-05 04:46:09.8 |
+0741-06-05 04:46:09.8 |
|
569931.398164 |
1560-06-02 09:33:21.4 |
+1560-06-02 09:33:21.4 |
1560-05-01 09:33:21.4 |
+1560-05-01 09:33:21.4 |
|
-47100.060188 |
-0129-01-16 22:33:19.8 |
-0129-01-16 22:33:19.8 |
-0129-00-15 22:33:19.8 |
-0129-00-15 22:33:19.8 |
|
78305.742371 |
0214-05-24 17:49:00.9 |
+0214-05-24 17:49:00.9 |
0214-04-23 17:49:00.9 |
+0214-04-23 17:49:00.9 |
|
-647059.390683 |
-1772-05-30 14:37:25.0 |
-1772-05-30 14:37:25.0 |
-1772-04-29 14:37:25.0 |
-1772-04-29 14:37:25.0 |
|
-777524.884547 |
-2129-03-18 02:46:15.1 |
-2129-03-18 02:46:15.1 |
-2129-02-17 02:46:15.1 |
-2129-02-17 02:46:15.1 |
|
-306367.880102 |
-0839-03-12 02:52:39.2 |
-0839-03-12 02:52:39.2 |
-0839-02-11 02:52:39.2 |
-0839-02-11 02:52:39.2 |
|
-589801.367590 |
-1615-03-06 15:10:40.2 |
-1615-03-06 15:10:40.2 |
-1615-02-05 15:10:40.2 |
-1615-02-05 15:10:40.2 |
|
534543.002937 |
1463-07-13 00:04:13.8 |
+1463-07-13 00:04:13.8 |
1463-06-12 00:04:13.8 |
+1463-06-12 00:04:13.8 |
|
-903764.326510 |
-2475-07-30 16:09:49.5 |
-2475-07-30 16:09:49.5 |
-2475-06-29 16:09:49.5 |
-2475-06-29 16:09:49.5 |
|
-340539.405843 |
-0933-08-20 14:15:35.2 |
-0933-08-20 14:15:35.2 |
-0933-07-19 14:15:35.2 |
-0933-07-19 14:15:35.2 |
|
-398540.527047 |
-1092-10-31 11:21:03.1 |
-1092-10-31 11:21:03.1 |
-1092-09-30 11:21:03.1 |
-1092-09-30 11:21:03.1 |
|
650903.318752 |
1782-02-10 07:39:00.2 |
+1782-02-10 07:39:00.2 |
1782-01-09 07:39:00.2 |
+1782-01-09 07:39:00.2 |
|
-444336.216178 |
-1217-06-13 18:48:42.2 |
-1217-06-13 18:48:42.2 |
-1217-05-12 18:48:42.2 |
-1217-05-12 18:48:42.2 |
|
-946962.943868 |
-2593-04-22 01:20:49.8 |
-2593-04-22 01:20:49.8 |
-2593-03-21 01:20:49.8 |
-2593-03-21 01:20:49.8 |
|
258276.231557 |
0707-02-20 05:33:26.5 |
+0707-02-20 05:33:26.5 |
0707-01-19 05:33:26.5 |
+0707-01-19 05:33:26.5 |
|
953597.264450 |
2610-11-11 06:20:48.5 |
+2610-11-11 06:20:48.5 |
2610-10-10 06:20:48.5 |
+2610-10-10 06:20:48.5 |
|
-137496.858519 |
-0377-07-19 03:23:44.0 |
-0377-07-19 03:23:44.0 |
-0377-06-18 03:23:44.0 |
-0377-06-18 03:23:44.0 |
|
-280000.690498 |
-0767-05-20 07:25:41.0 |
-0767-05-20 07:25:41.0 |
-0767-04-19 07:25:41.0 |
-0767-04-19 07:25:41.0 |
|
880701.656057 |
2411-04-12 15:44:43.3 |
+2411-04-12 15:44:43.3 |
2411-03-11 15:44:43.3 |
+2411-03-11 15:44:43.3 |
|
-120980.772457 |
-0332-10-06 05:27:39.7 |
-0332-10-06 05:27:39.7 |
-0332-09-05 05:27:39.7 |
-0332-09-05 05:27:39.7 |
|
224435.569751 |
0614-06-26 13:40:26.5 |
+0614-06-26 13:40:26.5 |
0614-05-25 13:40:26.5 |
+0614-05-25 13:40:26.5 |
|
776079.170303 |
2124-10-31 04:05:14.2 |
+2124-10-31 04:05:14.2 |
2124-09-30 04:05:14.2 |
+2124-09-30 04:05:14.2 |
|
-459861.198327 |
-1260-12-10 19:14:24.5 |
-1260-12-10 19:14:24.5 |
-1260-11-09 19:14:24.5 |
-1260-11-09 19:14:24.5 |
|
253535.113579 |
0694-02-26 02:43:33.2 |
+0694-02-26 02:43:33.2 |
0694-01-25 02:43:33.2 |
+0694-01-25 02:43:33.2 |
|
-257671.041079 |
-0706-07-08 23:00:50.8 |
-0706-07-08 23:00:50.8 |
-0706-06-07 23:00:50.8 |
-0706-06-07 23:00:50.8 |
|
-229719.110802 |
-0629-01-18 21:20:26.7 |
-0629-01-18 21:20:26.7 |
-0629-00-17 21:20:26.7 |
-0629-00-17 21:20:26.7 |
|
-365657.421119 |
-1002-11-11 13:53:35.3 |
-1002-11-11 13:53:35.3 |
-1002-10-10 13:53:35.3 |
-1002-10-10 13:53:35.3 |
|
175585.807790 |
0480-09-25 19:23:13.1 |
+0480-09-25 19:23:13.1 |
0480-08-24 19:23:13.1 |
+0480-08-24 19:23:13.1 |
|
-946514.252800 |
-2592-07-13 17:55:58.1 |
-2592-07-13 17:55:58.1 |
-2592-06-12 17:55:58.1 |
-2592-06-12 17:55:58.1 |
|
-805457.862792 |
-2206-09-24 03:17:34.8 |
-2206-09-24 03:17:34.8 |
-2206-08-23 03:17:34.8 |
-2206-08-23 03:17:34.8 |
|
-258177.145100 |
-0707-02-17 20:31:03.4 |
-0707-02-17 20:31:03.4 |
-0707-01-16 20:31:03.4 |
-0707-01-16 20:31:03.4 |
|
825946.658170 |
2261-05-13 15:47:45.9 |
+2261-05-13 15:47:45.9 |
2261-04-12 15:47:45.9 |
+2261-04-12 15:47:45.9 |
|
-226626.355359 |
-0621-07-08 15:28:17.0 |
-0621-07-08 15:28:17.0 |
-0621-06-07 15:28:17.0 |
-0621-06-07 15:28:17.0 |
|
419004.533794 |
1147-03-13 12:48:39.8 |
+1147-03-13 12:48:39.8 |
1147-02-12 12:48:39.8 |
+1147-02-12 12:48:39.8 |
|
-399579.439039 |
-1095-12-27 13:27:47.0 |
-1095-12-27 13:27:47.0 |
-1095-11-26 13:27:47.0 |
-1095-11-26 13:27:47.0 |
|
-720888.543687 |
-1974-04-10 10:57:05.4 |
-1974-04-10 10:57:05.4 |
-1974-03-09 10:57:05.4 |
-1974-03-09 10:57:05.4 |
|
-612616.204560 |
-1678-09-18 19:05:26.0 |
-1678-09-18 19:05:26.0 |
-1678-08-17 19:05:26.0 |
-1678-08-17 19:05:26.0 |
|
-743345.948524 |
-2036-10-15 01:14:07.5 |
-2036-10-15 01:14:07.5 |
-2036-09-14 01:14:07.5 |
-2036-09-14 01:14:07.5 |
|
353101.260431 |
0966-10-04 06:15:01.2 |
+0966-10-04 06:15:01.2 |
0966-09-03 06:15:01.2 |
+0966-09-03 06:15:01.2 |
|
-774772.285659 |
-2122-09-29 17:08:39.1 |
-2122-09-29 17:08:39.1 |
-2122-08-28 17:08:39.1 |
-2122-08-28 17:08:39.1 |
|
-486272.437494 |
-1332-08-18 13:30:00.5 |
-1332-08-18 13:30:00.5 |
-1332-07-17 13:30:00.5 |
-1332-07-17 13:30:00.5 |
|
373404.338881 |
1022-05-07 08:07:59.3 |
+1022-05-07 08:07:59.3 |
1022-04-06 08:07:59.3 |
+1022-04-06 08:07:59.3 |
|
-161319.085752 |
-0442-04-28 21:56:31.0 |
-0442-04-28 21:56:31.0 |
-0442-03-27 21:56:31.0 |
-0442-03-27 21:56:31.0 |
|
-248982.352025 |
-0682-04-23 15:33:05.0 |
-0682-04-23 15:33:05.0 |
-0682-03-22 15:33:05.0 |
-0682-03-22 15:33:05.0 |
|
215223.017631 |
0589-04-05 00:25:23.3 |
+0589-04-05 00:25:23.3 |
0589-03-04 00:25:23.3 |
+0589-03-04 00:25:23.3 |
|
-562568.465233 |
-1541-09-27 12:50:03.9 |
-1541-09-27 12:50:03.9 |
-1541-08-26 12:50:03.9 |
-1541-08-26 12:50:03.9 |
|
-929956.686427 |
-2547-11-12 07:31:32.7 |
-2547-11-12 07:31:32.7 |
-2547-10-11 07:31:32.7 |
-2547-10-11 07:31:32.7 |
|
-866815.457105 |
-2374-09-27 13:01:46.1 |
-2374-09-27 13:01:46.1 |
-2374-08-26 13:01:46.1 |
-2374-08-26 13:01:46.1 |
|
615.685042 |
0001-09-07 16:26:27.6 |
+0001-09-07 16:26:27.6 |
0001-08-06 16:26:27.6 |
+0001-08-06 16:26:27.6 |
|
272353.762758 |
0745-09-05 18:18:22.3 |
+0745-09-05 18:18:22.3 |
0745-08-04 18:18:22.3 |
+0745-08-04 18:18:22.3 |
|
893835.416232 |
2447-03-28 09:59:22.4 |
+2447-03-28 09:59:22.4 |
2447-02-27 09:59:22.4 |
+2447-02-27 09:59:22.4 |
|
-267127.044023 |
-0732-08-17 22:56:36.4 |
-0732-08-17 22:56:36.4 |
-0732-07-16 22:56:36.4 |
-0732-07-16 22:56:36.4 |
|
194527.765916 |
0532-08-06 18:22:55.1 |
+0532-08-06 18:22:55.1 |
0532-07-05 18:22:55.1 |
+0532-07-05 18:22:55.1 |
|
52854.435220 |
0144-09-16 10:26:43.0 |
+0144-09-16 10:26:43.0 |
0144-08-15 10:26:43.0 |
+0144-08-15 10:26:43.0 |
|
809014.889344 |
2215-01-03 21:20:39.3 |
+2215-01-03 21:20:39.3 |
2215-00-02 21:20:39.3 |
+2215-00-02 21:20:39.3 |
|
-455295.631048 |
-1247-06-11 08:51:17.5 |
-1247-06-11 08:51:17.5 |
-1247-05-10 08:51:17.5 |
-1247-05-10 08:51:17.5 |
|
-735146.998450 |
-2013-03-28 00:02:13.9 |
-2013-03-28 00:02:13.9 |
-2013-02-27 00:02:13.9 |
-2013-02-27 00:02:13.9 |
|
-965618.547335 |
-2644-03-23 10:51:50.3 |
-2644-03-23 10:51:50.3 |
-2644-02-22 10:51:50.3 |
-2644-02-22 10:51:50.3 |
|
-73632.263941 |
-0202-05-26 17:39:55.5 |
-0202-05-26 17:39:55.5 |
-0202-04-25 17:39:55.5 |
-0202-04-25 17:39:55.5 |
Comments
This Blog entry currently has no comments.
Post a Comment
Please Log In
To use this feature you must be logged into your Lottery Post account.
Not a member yet?
If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.
Register