Re: Conversion Algorithm for text into hours & minutes

Hello Simon,
If you're requirement is for the time value (eg '2:10') to be returned 
as text, the I would suggest a formula such as:

Let(T = GetAsNumber(YourTextField);
Int(T/60) & ":" & Right("00" & Mod(T; 60); 2)
)

However if you would like the hours and minutes returned as a standard 
FileMaker time value, then I'd suggest that you format the calc to 
return its result as Time and simply use:

GetAsNumber(YourTextField)

Regards,
Ray
----------------------------------------------------------
R J Cologon, Ph.D.,
Associate, FileMaker Solutions Alliance
FileMaker 7 Certified Developer
NightWing Enterprises, Melbourne, Australia
Email: CobaltSky-LyJzW+n/MtHP+dxuUfoltA@xxxxxxxxxxxxxxxx
http://www.nightwing.com.au/FileMaker
----------------------------------------------------------

On 31/03/2005, at 10:33 PM, Simon Manning wrote:
> Hi all,
>
> Does anyone have an algorithm to convert a text field (e.g. "130") 
> into Hours and Minutes (e.g. "2.10")
>
> Best regards,
>
>  Simon Manning
>  Systems Developer
>  IPS Web & Data Services
>  Cambridge University Press
>  University Printing House
>  Cambridge CB2 2RU
>  Tel:  + 44 (0)1223 325132 (direct)
>  Email:  smanning-eaSgp5hN2EDNLxjTenLetw@xxxxxxxxxxxxxxxx

--
To unsubscribe: send an email to 
<fmpexperts-off-YhOVfwX2n+1GPrOSNmeGdnHfP1ztnLDb@xxxxxxxxxxxxxxxx>
FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>