Microsoft Office Questions? Ask a IT Expert for Support ASAP
where can I send the file
Will need to carry on tomorrow evening as getting late will check my computer in the morning and upload the file to the site you suggest
Thanks for replying
Realized you must be far but thanks for replying.
yes they will put they will put there name in "D4" I will do this as a drop down list then when they press clock in this will save todays date in column "A" the last empty row it will also save current time in "B" same row and Put the formula in cell "D8" to the last row allowing the formula to change to that row this calculates there hours to the nearest 30mins and put their name in "E" last row, if they press this again on this date "Today" it will warn them they have clocked in but allow them to clock in on a new day date..
Clock Out button will check if they have clocked in if not will tell them they haven't clocked in and to clock in first and will do nothing unless they have clocked in first this will put the current time "HH:MM" in to the row that they clocked into that day.
Lunch button will copy from "D2" to the row "F" checking if they clocked in that day but does nothing if they have clocked in apart from telling them they have not clocked in yet
you've got the idea of it right cheers
no problem thanks