Hi!

Use a helper cell.

Set the limits of the spinner to:

Minimum value = 0
Maximum value = 96
Incremental change = 1

Assume the linked cell is A1

Format the helper cell as [h]:mm

Enter this formula in the helper cell:

=A1*15/1440

Biff

"Pat Hughes" wrote in message
...
I am making a form template in Excel 2000. Every time I try to enter a
spinner button I can't get it to work with time format. I want the time
to
be between 00:00 and 24:00 with 15 minute increments. I've tried with and
without the colons but nothing is working.