Thank you @kevlray for your help! With what you gave me and some other things I've read that were tangentially related, it sorted itself out in a dream (I know sad, right?).
The first thing I did was use a built in TimeDate function to calculate the elapsed time instead of pulling the text string of the elapsed time by using the Time() function in my formula.
I used the DateTime that the first unit was assigned and subtracted the DateTime that the call entered the queue which gave me the total seconds.
Time({Response_Master_Incident.Time_First_Unit_Assigned}) - Time({Response_Master_Incident.Time_CallEnteredQueue})
Then I used a string conversion formula as suggested by @DBlank in another thread to format it to display correctly (Display String in Format Field Dialog):
local numbervar RemainingSeconds;
local numbervar Hours ;
local numbervar Minutes;
local numbervar Seconds;
//divide the @TotalSeconds by 3600 to calculate
// hours. Use truncate to remove the decimal portion.
Hours := truncate(currentfieldvalue / 3600);
// Subtract the hours portion to get RemainingSeconds
RemainingSeconds := currentfieldvalue - (Hours *
3600);
// Divide RemainingSeconds by 60 to get minutes.
// Use truncate to remove the decimal portion.
Minutes := truncate(RemainingSeconds/60);
// Subtract the Hours and Minutes and what is left
// over is seconds.
Seconds := currentfieldvalue - (Hours * 3600) -
(Minutes * 60);
// Format the hours, minutes, and seconds to hh:mm:ss
totext(Hours,"00") + ":" + totext(Minutes,"00") +
":" + totext(Seconds,"00")
And now I can average, total, determine max and min values. Thank you so much for your patience and thank you for making this forum what it is.
Edited by KCowden - 22 Aug 2016 at 3:15am
IP Logged
