How to convert number into Time

[rpal]

I have a situation where I need to convert number into hours and minuts.

I am select dApplicatioStat.MaxCallsAbandonedDelay from view. MaxCallsAbandonedDelay is the number field , which I need to display in 'Hours and Minutes' Is there any formula to convert.

Thanks in advance for helping.

Raj.

 

[bdreed35]

Can you provide some sample data? THis will help someone here answer your question.

~Brian

 

[rpal]

Sample Data:

MaxCallsAbandonedDelay:
(In the database)
102
22
38

Above records I want to display in the report like :
01:42
00:22
00:38

Hope this is clear. Thanks.

 

[rpal]

I am able to solve this problem guys. Thanks all whoever working on this problem.

 

[MJRBIM]

Formula :

Time (Int ({Calls_txt.MaxCallsAbandonedDelay}/60),({Calls_txt.MaxCallsAbandonedDelay}-(Int ({Calls_txt.MaxCallsAbandonedDelay}/60)*60)),0 )

Format the results as 24 hour time.


MaxCallsAbandonedDelay HoursMin
- - - - - - - - - - - - - - - - - - - - - - - -
102 1:42
22 0:22
38 0:38
99 1:39
273 4:33