Time Spinner

[paulwjax]

Hey all. I'm trying to put a spinner to increase minutes in an hour to figure out productivity.

For instance: Click on the spinner button and it increases the time from

1:00 AM

1:15 AM


When I'm doing it I click the spinner and it increases the date and not the time.

Any suggestions?

 

[Debraj]

Hi paulwjax!!


Welcome to the forum..


* Create a Spin Button..

* Minimum Value : 0

* Maximum Value : 1440

* Incremental Change : 15

* Cell Link : A1


In B1 write Formula as : Today() + A1 / 1440

* Format B1 as TIME


Regards,

Deb

 

[paulwjax]

Thanks! I knew it was simple but just couldn't wrap my mind around it.