Converting Minutes to Hours & Minutes

[primagic]

I have a pdf form where the user enters hours and minutes for each day of the week.

So in one column they enter the hours - eg. 4 hours
In the other column they enter the mins - 40 minutes

I have another field which converts the 4 hours to minutes (4*60)

so I get a total mins (for the hours). I then add the minutes column and the mins (from the hours) to give me a total overall mintues eg. 500 minutes

How can I convert (in another textbox) the 500 minutes to hours and minutes. I tried divide by 60 but it gives me 8.3333.

Please help

Thanks
Andrew

 

[MakeItSo]

Take the initeger value of the division as your hours, then use

hours [b]%[/b] 60

to get the minutes.

The % operator gives you the remainder of a modulo division.

;-)

You could of course also just take the values of the separate text boxes, couldn't you?

Cheers,
MakeItSo

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[primagic]

Thank you. I managed to snoop about a bit and found this link which was exactly what I was after

http://forums.adobe.com/message/2757081