Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2015
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. <?php
  2.  
  3. date_default_timezone_set('Australia/Canberra');
  4.  
  5. $value = $objPHPExcel->getActiveSheet()->getCell('A1')->getValue();
  6.  
  7. define('MIN_DATES_DIFF', 25569);
  8. define('SEC_IN_DAY', 86400);
  9.  
  10. function excel2Timestamp($excelDate)
  11. {
  12. if($excelDate <= MIN_DATES_DIFF)
  13. {
  14. return 0;
  15. }
  16.  
  17. return ($excelDate - MIN_DATES_DIFF) * SEC_IN_DAY;
  18. }
  19.  
  20. echo $result = date('H:i:s d/m/Y', excel2Timestamp($value));
  21.  
  22. ?>
  23.  
  24. //get the excel date value (if it's stored in the A1 cell)
  25. $excelDate = $objPHPExcel->getActiveSheet()->getCell('A1')->getValue();
  26. //converts from excel format to a datetime object
  27. $date = PHPExcel_Shared_Date::ExcelToPHPObject($excelDate);
  28. //format the date as you want.
  29. $formatedDate = $date->format('m/d/Y');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement