时间戳和日期时间的转换

EXCEL表格里面的方法：

C语言实现的方法：

struct tm timeInfo = {0};

timeInfo.tm_sec = 0;           /* seconds after the minute, 0 to 60 (0 - 60 allows for the 
                                  occasional leap second) */
timeInfo.tm_min = 0;           /* minutes after the hour, 0 to 59 */
timeInfo.tm_hour = 0;          /* hours since midnight, 0 to 23 */
timeInfo.tm_mday = 1;          /* day of the month, 1 to 31 */
timeInfo.tm_mon = 0;           /* months since January, 0 to 11 */
timeInfo.tm_year = 2024-1900;  /* years since 1900 */
timeInfo.tm_isdst = 0; 
      
time_t timeStamp = mktime(&timeInfo);