change from text to Time

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
zMaestro Members Profile Find Members Posts Senior Member Joined: 11 May 2003 Location: Egypt Status: Offline Points: 1183	Post Options Post Reply Quote zMaestro Report Post Thanks(0) Quote Reply Topic: change from text to Time Posted: 12 September 2007 at 3:09pm
	Hi, in ASP, how can I change 11.8606 to 11:51 AM? :) thanks

KCWebMonkey Members Profile Find Members Posts Senior Member Go Chiefs! Joined: 21 June 2002 Status: Offline Points: 1319	Post Options Post Reply Quote KCWebMonkey Report Post Thanks(0) Quote Reply Posted: 17 September 2007 at 3:25am
	well, if .8606 is the same as 51/60, then i would guess there would have to be a calculation to see what the decimal amount is out of 60?

zMaestro Members Profile Find Members Posts Senior Member Joined: 11 May 2003 Location: Egypt Status: Offline Points: 1183	Post Options Post Reply Quote zMaestro Report Post Thanks(0) Quote Reply Posted: 17 September 2007 at 3:05pm
	times=Int(11.8606)&" : "& FormatNumber((((11.8606-Int(11.8606))*60)),0) something like this worked

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.