Re: [users] Round of in Calc

2008-10-02 Thread Brian Barker
At 11:38 02/10/2008 +0200, Erling Larsen wrote: I'm working on a spreadsheet for time-reporting. The result must be converted to decimal with two digits, and I'm doing this with: AVRUNDA(TIMME(H7)+(((100/60)*MINUT(H7))/100);2) Where avrunda = Round - timme = hour - minut = minute. This work

[users] Round of in Calc

2008-10-02 Thread Erling Larsen
I'm working on a spreadsheet for time-reporting. The result must be converted to decimal with two digits, and I'm doing this with: AVRUNDA(TIMME(H7)+(((100/60)*MINUT(H7))/100);2) Where avrunda = Round - timme = hour - minut = minute. This work fine but my problem is, that i need the second de