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?
hope this makes sense
IP Logged
