Formatting a number as hours and minutes

[Jim Devenish]

I have a numeric field (double) which holds a number of hours. I wish
to display this on a report 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?

[lyle]

On Apr 14, 12:43*pm, Jim Devenish <[e-mail]>
wrote:

I have a numeric field (double) which holds a number of hours. *I wish
to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

http://www.songsforteaching.com/stor...it-p-1027.html

[Jim Devenish]

On Apr 14, 6:12*pm, lyle <[e-mail]:

On Apr 14, 12:43*pm, Jim Devenish <[e-mail]>
wrote:

I have a numeric field (double) which holds a number of hours. *I wish
to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

http://www.songsforteaching.com/stor...-Miss-Jenny-CD...

Most helpful. Maybe the display of 3.2 should have been 03:12

[lyle]

On Apr 14, 1:45*pm, Jim Devenish <[e-mail]:

On Apr 14, 6:12*pm, lyle <[e-mail]:

On Apr 14, 12:43*pm, Jim Devenish <[e-mail]>
wrote:

I have a numeric field (double) which holds a number of hours. *I wish
to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

http://www.songsforteaching.com/stor...-Miss-Jenny-CD...

Most helpful. *Maybe the display of 3.2 should have been 03:12

Oh! Then maybe

Format([TheHours] / 24, "hh:nn")

[Jim Devenish]

On Apr 14, 7:38*pm, lyle <[e-mail]:

On Apr 14, 1:45*pm, Jim Devenish <[e-mail]:

On Apr 14, 6:12*pm, lyle <[e-mail]:

On Apr 14, 12:43*pm, Jim Devenish <[e-mail]>
wrote:

I have a numeric field (double) which holds a number of hours. *I wish
to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

>http://www.songsforteaching.com/stor...-Miss-Jenny-CD....

Most helpful. *Maybe the display of 3.2 should have been 03:12

Oh! Then maybe

Format([TheHours] / 24, "hh:nn")

That's a good start. Now I will work out how to represent it when
theHours>24.

[Salad]

lyle wrote:

On Apr 14, 12:43 pm, Jim Devenish <[e-mail]>
wrote:

>>I have a numeric field (double) which holds a number of hours. I wish
to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

http://www.songsforteaching.com/stor...it-p-1027.html

There was a cartoon in my local Saturday newspaper and I thought I'd
pass it on to you. The strip is called "Rhymes with Orange". Caption 1
says "Lyle's very short career in Forestry". In the second caption
theres a few stumps and logs, one tree slanted downward and a man with a
chain saw in front of a tree and he's looking around asking "Tim who?"

http://seattlepi.nwsource.com/fun/rh...?date=20080412

[lyle]

On Apr 14, 2:45*pm, Jim Devenish <[e-mail]:

On Apr 14, 7:38*pm, lyle <[e-mail]:

On Apr 14, 1:45*pm, Jim Devenish <[e-mail]:

On Apr 14, 6:12*pm, lyle <[e-mail]:

On Apr 14, 12:43*pm, Jim Devenish <[e-mail]>
wrote:

I have a numeric field (double) which holds a number of hours. *I wish
to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

http://www.songsforteaching.com/stor...-Miss-Jenny-CD....

Most helpful. *Maybe the display of 3.2 should have been 03:12

Oh! Then maybe

Format([TheHours] / 24, "hh:nn")

That's a good start. *Now I will work out how to represent it when
theHours>24.

Let us know! I guess you've worked out what the results are that you
want for say

36.5 ?

Maybe

1 12:30

or

36:30

or

12:30.

????????

[Jim Devenish]

On Apr 14, 10:57*pm, lyle <[e-mail]:

On Apr 14, 2:45*pm, Jim Devenish <[e-mail]:

On Apr 14, 7:38*pm, lyle <[e-mail]:

On Apr 14, 1:45*pm, Jim Devenish <[e-mail]:

On Apr 14, 6:12*pm, lyle <[e-mail]:

On Apr 14, 12:43*pm, Jim Devenish <[e-mail]>
wrote:

I have a numeric field (double) which holds a number of hours. *I wish
to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

>http://www.songsforteaching.com/stor...-Miss-Jenny-CD...

Most helpful. *Maybe the display of 3.2 should have been 03:12

Oh! Then maybe

Format([TheHours] / 24, "hh:nn")

That's a good start. *Now I will work out how to represent it when
theHours>24.

Let us know! I guess you've worked out what the results are that you
want for say

36.5 ?

Maybe

1 12:30

or

36:30

or

12:30.

????????

I want the display to be 36:30. Simply hours and minutes.

[lyle fairfield]

Jim Devenish <in***************@foobox.comwrote in
news:70**********************************@r9g2000p rd.googlegroups.com:

On Apr 14, 10:57*pm, lyle <[e-mail]:

>On Apr 14, 2:45*pm, Jim Devenish <[e-mail]>
wrote:

On Apr 14, 7:38*pm, lyle <[e-mail]:

On Apr 14, 1:45*pm, Jim Devenish <[e-mail]>
wrot

e:

>>

On Apr 14, 6:12*pm, lyle <[e-mail]:

On Apr 14, 12:43*pm, Jim Devenish
<[e-mail]>

wrote:

I have a numeric field (double) which holds a number of
hours.

*I wish

to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

>http://www.songsforteaching.com/stor...h-with-Miss-Je
>nny-

CD...

>>

Most helpful. *Maybe the display of 3.2 should have been 03:12

Oh! Then maybe

Format([TheHours] / 24, "hh:nn")

That's a good start. *Now I will work out how to represent it when
theHours>24.

Let us know! I guess you've worked out what the results are that you
want for say

36.5 ?

Maybe

1 12:30

or

36:30

or

12:30.

????????

I want the display to be 36:30. Simply hours and minutes.

Public Function whatever()
Dim TheHours#

TheHours = 2.5
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 1.25
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 3.2
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 36.5
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 12345636.573489
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 0.573489
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

End Function

2:30
1:15
3:12
36:30
12345636:34
0:34

[Jim Devenish]

On Apr 14, 11:34*pm, lyle fairfield <[e-mail]:

Jim Devenish <[e-mail] innews:70**********************************@r9g200 0prd.googlegroups.com:

On Apr 14, 10:57*pm, lyle <[e-mail]:

On Apr 14, 2:45*pm, Jim Devenish <[e-mail]>
wrote:

On Apr 14, 7:38*pm, lyle <[e-mail]:

On Apr 14, 1:45*pm, Jim Devenish <[e-mail]>
wrot

e:

On Apr 14, 6:12*pm, lyle <[e-mail]:

On Apr 14, 12:43*pm, Jim Devenish
<[e-mail]>

wrote:

I have a numeric field (double) which holds a number of
hours.

*I wish

to display this on a report 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?

Maybe "We Love Math with Miss Jenny" ?

>http://www.songsforteaching.com/stor...h-with-Miss-Je
>nny-

CD...

Most helpful. *Maybe the display of 3.2 should have been 03:12

Oh! Then maybe

Format([TheHours] / 24, "hh:nn")

That's a good start. *Now I will work out how to represent it when
theHours>24.

Let us know! I guess you've worked out what the results are that you
want for say

36.5 ?

Maybe

1 12:30

or

36:30

or

12:30.

????????

I want the display to be 36:30. *Simply hours and minutes.

Public Function whatever()
Dim TheHours#

TheHours = 2.5
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 1.25
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 3.2
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 36.5
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 12345636.573489
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

TheHours = 0.573489
Debug.Print Format(-(-Int(TheHours)), "#0") & Format(TheHours / 24, "\:nn")

End Function

2:30
1:15
3:12
36:30
12345636:34
0:34

Many thanks. Works a charm.

Not sure why you have put in a double negative: Format(-(-Int ....
I had not appreciated that to display the minutes, the first argument
to Format needed to be in days.