IwannaBeLikeU
New Member
- Joined
- Nov 29, 2016
- Messages
- 11
Call center data - due to the number of records, I'm importing call data into Access and setting the time field type to "date with time" and displaying hh:mm:ss. When I import this data into PowerPivot for Excel consumption, I create a pivot table and try to average the time data, but I get an error message due to the type of data. So now I'm thinking I'll convert the HH:MM:SS to seconds, but I'm having an issue with the DAX formula.
"=HOUR('Contact_History 18'[Handle Time])*3600+minute('Contact_History 18'[Handle Time]*60)+Second('Contact_History 18'[Handle Time])"
For 00:08:10 I get a result of 20.00 (That should say 490 seconds)
Any help on this matter would be greatly appreciated.
"=HOUR('Contact_History 18'[Handle Time])*3600+minute('Contact_History 18'[Handle Time]*60)+Second('Contact_History 18'[Handle Time])"
For 00:08:10 I get a result of 20.00 (That should say 490 seconds)
Any help on this matter would be greatly appreciated.