Erling Larsen wrote:
... This work fine but my problem is, that i need the second decimal to be either 0 or 5.
Your calculation works, but it is more complicated than it needs to be. Calc always stores times as decimal values, but in days, not hours.
All you should need is =MROUND(H7*24;0.05) <Joe --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
