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
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