Converting Elapsed time into HH:mm

[m3gd04]

Newbie here with simple question In Business Objects.


Field 1 = Start Time ( which is a dimension)
Field 2 = Stop Time ( dimension again)
Field 3 = Elapsed Time ( measure)

Example:

Room Time Start Time Room Time Stop Elapsed Time
10:07 11:53 106

I want to create a variable that will show the 106 as 1:46 ( one hour and forty six minutes)

Of course after dividing by 60 I get 1.77 and tried to reformat as HH:mm with no luck

Any advise would be greatly appreciated...

 

[dbomrrsm]

Is this any help:

http://support.businessobjects.com/library/kbase/articles/c2008378.asp

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[blom0344]

Look here, it has all been done before:

http://www.tek-tips.com/viewthread.cfm?qid=692219

Ties Blom
Information analyst