Off the top of my head... Add 2 real number fields. ztmp_CalculateTime ztmp_CalculateTimeHour
Add 1 character field ztmp_CalculateTimeDisplay 1 Active link or filter with 5 set field actions. Set field Action 1, Set ztmp_CalculateTime = $YourSourceField$ Set field Action 2, Set ztmp_CalculateTime = $ztmp_CalculateTime$ / 60 Set field Action 3, Set ztmp_CalculateTimeHour = LEFT($ztmp_CalculateTimeHour$, (STRSTR($ztmp_CalculateTime$, "."))) Set field Action 4, Set ztmp_CalculateTime = $ztmp_CalculateTime$ - $ztmp_CalculateTimeHour$ Set field Action 5, Set ztmp_CalculateTimeDisplay = ($ztmp_CalculateTimeHour$ + ".") + LEFT(($ztmp_CalculateTime$ * 60), 2) Alternate step 5 as plain text Set field Action 5, Set ztmp_CalculateTimeDisplay = (($ztmp_CalculateTimeHour$ + " Hour(s) ") + LEFT(($ztmp_CalculateTime$ * 60), 2)) + " Minute(s)" Jason ________________________________ From: Jase Brandon <[email protected]> To: [email protected] Sent: Tue, March 22, 2011 7:18:32 PM Subject: Re: Trying to convert Integer field value into Hours divided by 60. ** Thanks Christie and Fred, I should have mentioned I've already tried using Real, Integer, Char, etc. I should have stated: "I want to be able to take a value of "61" in any type field, and convert that somehow to be interpreted as 'Total Time' = "1.01" or "One Hour One Minute", etc.. in any format. What would you guys suggest for accomplishing this goal? I'm admittedly tired and frustrated right now. Thanks in Advance... :-) Jase :-) On Tue, Mar 22, 2011 at 6:41 PM, Grooms, Frederick W <[email protected]> wrote: Since you are doing integer math it is truncating the remainder > >You state 'Total Time' is an integer so it can never show 6.08 > >Fred > > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[email protected]] On Behalf Of Jase Brandon >Sent: Tuesday, March 22, 2011 5:17 PM >To: [email protected] >Subject: Trying to convert Integer field value into Hours divided by 60. > > >** Hello All, >I am writing a custom time tracking app and have been banging my head on the >keyboard for a few hours with the below. > >I have one Active Link and three fields: 'Minutes', 'Hours', and 'Total Time' >all are Integer/Numeric Spinner/Display Only. >'Minutes' and 'Hours' are populated by a COLSUM functions on a table field and >that part is working great. >I want to be able to take 'Minutes' and 'Hours' and populate 'Total Time' >field, >so a user can do a date range search on Monday-Friday and see if they have >entered a full 40 hours. >My problem is this: > >'Hours' and 'Minutes' both work great and are populated with the correct >values >from the table field using COLSUM. > >I have an Active Link with three Set Fields. >Action 1: Set Fields 'Hours' = COLSUM(Column38). >Action 2: Set Fields 'Minutes' COLSUM(Column39). >Action 3: Set Fields 'Total Time' = 'Hours' + ('Minutes' /60) > >Action 3 is what is causing the pain. > >Ex >Action 1 uses COLSUM and sets the 'Hours' as 4 hours, and that's correct. >Action 2 does the same COLSUM function and comes up with 128 Minutes, and >that's >correct. >Action 3 sets 'Total Hours' as 6 Hours with NO minutes. So, the workflow it's >picking up the fact that when I divide by 60 in action 3 it works, but... it's >not taking into account the other 8 minutes. >So the problem is that when 'Hours' = 4, and 'Minutes' = 128... I get the >result >in 'Total Time' as 6, instead of 6.08. I need the 'Total Time' field to >populate >with exact Hours/Minutes. > >The only thing I have come close with if using another Decimal Integer field >with a Precision of 2 as 'Total Time'.. but.. that gives me a time of "2.13" >for >"2 Hours and 8 Minutes", as it should. 13% of 60 is 8. >How can I overcome this? I haven't done anything like this in quite awhile and >I >am admittedly stumped. > >ARS 7.1 >Windows 2003 >ITSM 7.0.0.3 > >Thanks in Advance to All with any advice for me. :-) > >Cheers, > >Jase Brandon >Senior Remedy Developer >Quality Technology Services >300 Satellite Blvd >Suwanee, GA 30024 > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

