You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Convert and Sum a Text Field to a Time Field

edited Jun 19, 2017 3:18PM in Reporting & Analytics for B2C Service 1 comment

Content

I am attempting to Sum the total of Hours and Minutes of a text field for a report.  The current text format is HH:MM.  I need it converted into HH:MM numbers and summed.   I have tried various to_number expression options without success   example:  sum(((to_number(substr(TimeTrack$TimeTracking.CompletionTime,1,2))*60)+to_number(substr(TimeTrack$TimeTracking.CompletionTime,4,2))))/60

Any suggestions.

 

Thanks

 

Version

Service Cloud
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!