ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   attendance log (https://www.excelbanter.com/new-users-excel/129280-attendance-log.html)

gloria's day care

attendance log
 
I need to set up an attendance log for my day care. It needs to include in
and out times.

Ian

attendance log
 
working with time can be tough. If it's one or two people inputting the data
I would Make 4 columns:
C1 - Name of Child (look under validaton to create a drop down list of the
kids)
C2 - Date/Time In (set the format the cell to Date & 3/14/01 1:45PM)
C3 - Same as C2
C4 - C3-C2 and set the format to custom [mm] this will give you the
number of minutes the child is present.

Does this help?

"gloria's day care" wrote:

I need to set up an attendance log for my day care. It needs to include in
and out times.



All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com