Convert digital time to hours and minutes

I

Ian

Does anybody know how to format or create an expression
to show a number, such as 1.5, to display as 1:30, both
represting 1 and a half hours?
 
S

Steve Schapel

Ian,

Try something like this...
Int([YourNumber]) & ":" & ([YourNumber]-Int([YourNumber]))*60
 
Top