Hi, I am creating an automated clocking in/out system.
My spreadsheet runs on a five day week from Monday to Friday.
The spreadsheet has four boxes for each day - book in AM, book out AM,
book in PM and book out PM.

I have two buttons at the bottom of the table - Book in and Book out. I
am having problems making these buttons do what I want them to do.

I have cells containing the formulae to display the current date,
current day and current time.

I want my spreadsheet to be automated, so that when I press the 'Book
in' button, the program will pick up what day it is from my date and
day cells, as well as whether or not it is in the morning or afternoon,
according to my current time cell.

From this information I want it to record the time in the correct "Book
in AM" or "Book in PM" cell of the correct day.

What would be the best way to go about doing this. I considered using
an IF function in the programming, what's the simplest way, has anyone
done something similar before?

Thanks in advance for any feedback :)


---
Message posted from http://www.ExcelForum.com/