dinsdag 2 september 2008

Numbers In Base 12

=INT(B7/12)*100+MOD(B7,12)
In this case, the formule cell would contain 2809,
which could be easily displayed in the final format
by setting the custom number format for the cell
as 0":"00.

Geen opmerkingen: