What funcition to use and how to set up

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 10:03 PM GMT

Question

 We run an afterschool club and would like to set up spreadsheet to help me invoice the parents at the end of each term.

The club runs from 3.30pm to 5.45pm monday to firday, I would like to enter the time they finish each day andto caluclate the number of hour for the week. I'm not sure what i need to use eg <if> of pivot tables

Answer

There are many different techniques inyou can use to break apart dates or times into their component parts, add or subtract dates, and figure out how much time is elapsed between two dates.

Read this free tutorial from my web site that explains how to work with adding dates and times in Excel:

http://599cd.com/tips/excel/adding-dates-times/?key=AllExperts

I also have this FREE video tutorial that shows you how to get month names (like "September") from dates:

http://599cd.com/tips/excel/month-names/?key=AllExperts

Advertisement

©2017 eLuminary LLC. All rights reserved.