I have an import that includes the date and time as one string 2013/04/16/00. The would be the date of 4/16/2013 and the time of 0:00. I can pull the date out with:
=DATE(LEFT('Chat Split Skill Summary'!B5,4), MID('Chat Split Skill Summary'!B5,6,2), MID('Chat Split Skill Summary'!B5,9,2))
I need to pull the two digit time out and format it as 00:00. I tried =HOUR(RIGHT('Chat Split Skill Summary'!B5,2)) but it does not recognize the the two digits as the hour. It seems to think it is the minutes. When I drag it down one field to get 01, I still get a value of 0:00.
Can someone get this to recognize the hour?
Thanks,
Jeff
=DATE(LEFT('Chat Split Skill Summary'!B5,4), MID('Chat Split Skill Summary'!B5,6,2), MID('Chat Split Skill Summary'!B5,9,2))
I need to pull the two digit time out and format it as 00:00. I tried =HOUR(RIGHT('Chat Split Skill Summary'!B5,2)) but it does not recognize the the two digits as the hour. It seems to think it is the minutes. When I drag it down one field to get 01, I still get a value of 0:00.
Can someone get this to recognize the hour?
Thanks,
Jeff