I have a unique problem with converting the HHHH:mm:ss to integer values in datameer. I did an import job in datameer from an excel file that has the raw data for total hours in a day/week/month for Calls Answered in a call center. The values for a particular month, when i bring it into datameer as a DATE data type, from the excel file looks like this
Excel Hours for a Month
July 29, 1900 01:35:47 PM
I tried to strip the date timestamp by converting it into int values for hours, minutes and seconds respectively, using format date.
It worked for minutes and seconds. However, for hours i am running into an issue. It is calculating the hours based on the time stamp for a given 24 hours a day value. So if the time stamp states 01:35:47 pm, it is giving me hours between the ranges of 12-24. How do i tackle this issue?
Please sign in to leave a comment.