| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting up time sheets in excel with total hours
I have an in home day care and need a way to use excel to track the drop off
time and pick up time for the child, then I need to total the daily hours. example drop off d3 8:00am pick up f3 2:00pm total hours g3please help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting up time sheets in excel with total hours
It is simply
=F2-D2 and format all cells a time, but G3 as hh:mm, not with AM/PM. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vremington" wrote in message ... I have an in home day care and need a way to use excel to track the drop off time and pick up time for the child, then I need to total the daily hours. example drop off d3 8:00am pick up f3 2:00pm total hours g3please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get total amount of hours in time format | Excel Discussion (Misc queries) | |||
| add 10,0015:15 hours to 03:53 Hours to a total time | Excel Worksheet Functions | |||
| Total time vs hours per shift | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Linear Mode
