Topic: Problems converting % of minutes to actual minutes Posted: 14 Nov 2013 at 4:22am
Hi there,
I'm having a problem doing a Mod operation in Crystal 2008 and I'm not even sure this is the best approahc.
Here's my scenario:
Minutes = 167
I want to display this in hours and minutes so it breaks down to 2.78 (2 hours and 78/100). I want to display the ".78" but equate it in minutes "47" (rounded)
So the end goal is to display 167 minutes as 2.47 as a number for additional math operations. My approach was to use the Mod operator but I'm having a problem getting the exact syntax. Tried many variations of either Remainder or Mod but to no successful outcome.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum