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?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.