| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
time sheets using hours and totals
I run an in home day care and I am using excel 2003 for my clients sign in
-sign out sheets. When they drop off their child they write down the time, same thing when they pick up the child. I need to add the total hours of time in & out for the day. then I need to multiplie the total daily hours by the amount I charge. I have been unable to figure out how to do this. example d3 would be 8:10am time in and f3 would be 2:00pm time out and I need total hours in g3 can you help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to add time totals over 24 hours | Excel Worksheet Functions | |||
| using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
| Time sheets and hours | Excel Discussion (Misc queries) | |||
| Apply a macro to all sheets - save me from hours and hours of work | Excel Programming | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Threaded Mode
