Converting integer to separate fields for hours and minutes 1

[m3gd04]

Simple question...

I would like to convert a field showing minutes into 2 separate fields, one for hours and one for minutes...

For example, If I have a field that shows 80 minute, I'd like for the end result to show 1 hour in one field and and 20 minutes in another.

Any help would be appreciated.

 

[kray4660]

Is this a Crystal Report or WebI or DeskI? Each one would work a little different, but two formulas would need to be created. One for the minute calculation, and one for the hour calculation.

I hope this helps.

 

[m3gd04]

oops forgot to mention that this was Business Objects 5.5

I can calculate the hour one, but I can't seem to get the minutes to reflect the way I want to.

I appreciate the advice....

 

[m3gd04]

All solved...

Thanks for pointing me in right direction Kray.

 

[SkipVought]

OriginalMinutes = 80

Hours = INT(OriginalMinutes/60)

Minutes = OriginalMinutes - (Hours * 60)

I think I learned that in 5[sup]th[/sup] grade or maybe it was a TV show.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]