Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Formatting a nu...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 10 Topic 29956 of 31576
Post > Topic >>

Formatting a number as hours and minutes

by Jim Devenish <internet.shopping@[EMAIL PROTECTED] > Apr 14, 2008 at 09:43 AM

I have a numeric field (double) which holds a number of hours.  I wish
to display this on a re****t in the form of hours and minutes.

E.g.
2.5 to be displayed as 02:30
1.25 as 01:15
3.2   as 03.20

Using Format([theHours],"hh:nn") does not do it.

Any ideas?
 




 10 Posts in Topic:
Formatting a number as hours and minutes
Jim Devenish <internet  2008-04-14 09:43:56 
Re: Formatting a number as hours and minutes
lyle <lyle.fairfield@[  2008-04-14 10:12:21 
Re: Formatting a number as hours and minutes
Salad <oil@[EMAIL PROT  2008-04-14 12:28:33 
Re: Formatting a number as hours and minutes
Jim Devenish <internet  2008-04-14 10:45:59 
Re: Formatting a number as hours and minutes
lyle <lyle.fairfield@[  2008-04-14 11:38:17 
Re: Formatting a number as hours and minutes
Jim Devenish <internet  2008-04-14 11:45:07 
Re: Formatting a number as hours and minutes
lyle <lyle.fairfield@[  2008-04-14 14:57:38 
Re: Formatting a number as hours and minutes
Jim Devenish <internet  2008-04-14 15:19:39 
Re: Formatting a number as hours and minutes
lyle fairfield <lylefa  2008-04-14 22:34:43 
Re: Formatting a number as hours and minutes
Jim Devenish <internet  2008-04-15 04:36:15 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 1:39:20 CST 2008.