Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display a number as a time 1

Status
Not open for further replies.

janedane

Programmer
Mar 8, 2004
22
IE
Crystal 9.0

Hi All,
I have a number field which is actually an appointment time. Is there a way I can display the number as a time
i.e 1020->10.20, 843->8.43

Thanks,
Jane
 
This formula would return it as a formatted string:
[tt]
NumberVar x := 1020;
ToText(x/100,2);
[/tt]
This formula would return it as a Time datatype:
[tt]
NumberVar x := 1020;
Time(Int(x/100), x Mod 100, 0);
[/tt]
-dave

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top