Excel template for daycare billing?
October 9, 2007 8:43 AM Subscribe
Looking for an Excel template to track children's time (billable hours) over a month.
posted by OlderThanTOS to Computers & Internet (6 answers total) 2 users marked this as a favorite
I am looking for an Excel template/formula that will:
1. Allow entry of daily arrival and pickup time for each child (20-30 total kids), in the form "3:15 pm" or maybe "3:15" (definitely not 15:15).
2. Subtract departure time from arrival, giving a number of hours, i.e. 3.5 hours.
If there is some Excel formula to do this, please post it! I've fiddled with TIME() and TIMEVALUE() fxns with no success. This is for employees who are not programmers and actually fairly computer-phobic, so it should be simple and sturdy (and free--it's a non-profit).