days, hours, minutes 1

[imstillatwork]

here is what i have...

each row has a start and end date,
I use datediff to find the minutes between each date.
I add all the minutes (totaltime) and divide by total rows(issuecount) to get the average time in minutes. Then break it down into days, hours, minutes...

like this:

				<cfset minute=evaluate(totaltime/issuecount)>
				<cfset hour=evaluate((minute -(minute MOD 60))/60)>
				<cfset day=evaluate((minute -(minute MOD 1440))/1440)>

				#day# day, #hour# hours, #evaluate(minute MOD 60)# mins <br>

the problem is that the MOD does not like it if the average time from datediff has a decimal...
what is the most accurat way to fix this?

thanks
kevin

 

[imstillatwork]

um....well, that code i posted is crap...can someone help me? I know its the weekend, but please? ?

thanks

I am given a number that is possibly decimal, it is minutes. want to display it in X days, X hours, X minutes.

thanks

 

[webmigit]

You could find the position of the decimal using Find() and then chop it off right at that point, no?

Tony

 

[imstillatwork]

yeah that would work, but you could be chopping off up to 23 hours, 59 minutes, and i want it to be more accurate than that. I'll build somethign like what i started up there, but need to keep track of the remainders better. lemme know if you come up with something.

saw your IM, but came in late.

 

[imstillatwork]

nevermind, you would only be killing up to one minute...I soo need a break from this stuff! :/ thanks

kevin