setting up time sheets in excel with total hours

V

vremington

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
 
B

Bob Phillips

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)
 

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.

Ask a Question

Similar Threads

time sheets using hours and totals 1
Add Hours by Looping through Data Q 27
TIME CALCULATION 8
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Need Help 5
Tracking Driver Hours 2
Timesheet formula problem 3
Compute Additional Hours Needed Using "if" or "lookup" 1

Top