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