<cfset min = 400 mod 60>
<cfset hr = Fix(400/60)>

Use the modulus to get the remainder, and use fix to get the Floor of the
division.


Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developers Resources
http://www.cfdev.com/

-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 9:46 AM
To: CF-Talk
Subject: SLightly OT - a time formula


Hi all,

This is slightly OT, but refers to a cf project so I guess it is relevant in
a way. Does anyone know a formula for calculating time. I have numbers of
minutes, and need to calculate the time in hours and minutes from these.

For example, I have the figure of 400 minutes. I need to calculate how many
hours and minutes this is. Dividing by 60 won't do the job, it gives an
answer of 6.66666666. What I need is a formula that will give me the correct
answer: 6hrs 40minutes.

Anyone know a nice formula for calculating this?

TIA

Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to