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 fine but my problem is, that i need the second decimal to be
either 0 or 5.
Can this be done?
Erling Larsen
Try this:
=HOUR(H7)+ROUND(2*MINUTE(H7)/60;1)/2
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]