Decimal number convert to HH:MM

[antiskeptic]

I know I've seen this formula before...but I can't for the life of me remember it. *argh*

I have a field that displays a number 40.5...I need it to display in hours and minutes...like this - 40:30

Anybody got any ideas?

Sincerely,
Antiskeptic

 

[Madawc]

You need Time (number) to convert it to a time. Then Time (HH, MM) will display it.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5.


Madawc Williams (East Anglia, UK)

 

[antiskeptic]

Sorry...I wasn't even thinking about the version having any real bearing on this problem...but you are right, I guess it could. I am working with version 9.

Good point Madawc, thank you!

Antiskeptic