Try this
<cfset Hours=int(totalMins/60)>
<cfset Minutes=totalMins Mod 60>
Therefore with 400 Mins you get
Hours=int(400/60)=6
Mins=400 Mod 6= 40
Back Calc = (6*60)+40=360+40=400
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-----Original Message-----
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2001 14:46
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
