Convert digital time to hours and minutes

[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?

 

[Steve Schapel]

Ian,

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

 

[Ian]

Thanks, your suggestion worked great. I just had to
modify it a little to account for a 0 minute and 5 minute
time so that it displays, for example, 1:05 and not just
1:5

-----Original Message-----
Ian,

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

--
Steve Schapel, Microsoft Access MVP

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?

.