Hi all,
Hope you are well in this trying time.
I have pulled a report of meetings with their start datetime and end datetime, as I want to do a volume analysis for how many meetings took place per hour window, one what days etc.
However, the report I pulled from our CRM shows the datetime value as a number in the 44000s for start and end and, even when I convert format of that number to short date for date and time for the time, I still cannot undertake proper analysis. How do I convert (not by just changing the format type) and separate these dates so I have the following columns:
- Meeting Name
- Start Date in the format DD/MM/YY with the format type as 'General' (ie not by setting it to 'Date') so I can extract the day numbers from it
- Start Time in the format HH:MM:SS with the format type as 'General' (ie not by setting it to 'Time') so I can extract the hours only from it
- End Date in the format DD/MM/YY with the format type as 'General' (ie not by setting it to 'Date') so I can extract the day numbers from it
- End Time in the format HH:MM:SS with the format type as 'General' (ie not by setting it to 'Time') so I can extract the hours only from it
I have attached the workbook to this. Thanks in advance for any help.
Bookmarks