FormattedPHPToExcel1900.php 1.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
  1. <?php
  2. // Year Month Day Hours Minutes Seconds Result Comments
  3. return [
  4. // PHP 32-bit Earliest Date 14-Dec-1901
  5. [
  6. 714,
  7. 1901,
  8. 12,
  9. 14,
  10. ],
  11. // 31-Dec-1903
  12. [
  13. 1461,
  14. 1903,
  15. 12,
  16. 31,
  17. ],
  18. // Excel 1904 Calendar Base Date 01-Jan-1904
  19. [
  20. 1462,
  21. 1904,
  22. 1,
  23. 1,
  24. ],
  25. // 02-Jan-1904
  26. [
  27. 1463,
  28. 1904,
  29. 1,
  30. 2,
  31. ],
  32. // 19-Dec-1960
  33. [
  34. 22269,
  35. 1960,
  36. 12,
  37. 19,
  38. ],
  39. // PHP Base Date 01-Jan-1970
  40. [
  41. 25569,
  42. 1970,
  43. 1,
  44. 1,
  45. ],
  46. // 07-Dec-1982
  47. [
  48. 30292,
  49. 1982,
  50. 12,
  51. 7,
  52. ],
  53. // 12-Jun-2008
  54. [
  55. 39611,
  56. 2008,
  57. 6,
  58. 12,
  59. ],
  60. // PHP 32-bit Latest Date 19-Jan-2038
  61. [
  62. 50424,
  63. 2038,
  64. 1,
  65. 19,
  66. ],
  67. // 18-May-1903 13:37:46
  68. [
  69. 1234.56789,
  70. 1903,
  71. 5,
  72. 18,
  73. 13,
  74. 37,
  75. 46,
  76. ],
  77. // 18-Oct-1933 16:17:37
  78. [
  79. 12345.6789,
  80. 1933,
  81. 10,
  82. 18,
  83. 16,
  84. 17,
  85. 37,
  86. ],
  87. ];