Joined: 18 Aug 2010
Online Status: Offline
Posts: 5
Topic: hours issue Posted: 29 Sep 2010 at 3:33am
Can anyone help me, i have multipul hours field in my database that i am getting the sum to show, but when it reaches 60minutes i want it to show as 1 hour but in crystal reports, it will keep going until 99 then go to 1.
example
1.15 and 1.50 would be 3hours 05 minutes but my report will show 2.65.
is there away i can cap it at 59 then it goes to 1hr?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 13 Oct 2010 at 3:33am
if they are datetime fields, I would use DateAdd() with the minute function into a variable (maybe shared) and then convert it to the time you want (probably toText(variable, "hh:mm") )...just remember to reset the variable if shared/global.
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
IP Logged
