转换MMM DD，YYYY HH：MM：SS am in excel [英] convert MMM DD, YYYY HH:MM:SS am in excel

问题描述

我有一个电子表格，其中包含我网站的加载时间。我想找到我的网站的高峰时间。

I have a spreadsheet which contains the loading times for my website. I want to find the peak hour for my website.

但是日期以以下格式存储：

However the dates are stored in the following format:

Jun 02, 2014 01:13:08 am
MMM DD, YYYY HH:MM:SS am / pm

如何将这个转换为excel会明白的日期？

How can I convert this in to date that excel will understand?

推荐答案

要将伪日期转换为实际日期，请选择它们并运行：

To convert your "pseudo-dates" into real dates, select them and run:

Sub ConvertDates()
    Dim r As Range
    For Each r In Selection
        r.Value = CDate(r.Text)
    Next r
End Sub

这篇关于转换MMM DD，YYYY HH：MM：SS am in excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！