I was given an Excel spreadsheet with call metrics. When this report is run, the time fields display in MM:SS (ex. 4:53). When it is exported, Excel changes it to a time format. 04:53:00 AM. When I bring the the spreadsheet into Alteryx, 04:53:00 is shown. Is there a formula or way to get this into a HH:MM:SS view to show 00:04:53 to represent being on the phone for four minutes and fifty three seconds?
i need help in converting the timezone into a different one so i inserted a formula to combine the date and time but it has removed the AM/PM and the combined date and time doesn't reflect in military time. It just combined the date and time but the time is not reflecting as the correct one. 02:50:45 PM only shows as 02:50:45 so that makes it 02:50 AM.
if someone could also show me how to convert the date and time?