| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
=Text(b2-A2,"h") hours between 2 times, what do I do for 10 times
I am trying to do a work schedule for work. I am using an excel worksheet
and typing the starting time ex. 8:00 am in Cell A2 and ending time 5:00 pm in Cell B2. I need to add the total hours worked for two full weeks. I have the formula =TEXT(B2-A2,"h"), which adds the hours for the first day. What formula do I use to add the following days to this formula to get a total for two full weeks. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find the amount of hours between times? | Excel Discussion (Misc queries) | |||
| totaling times past 24 hours | Excel Worksheet Functions | |||
| calculate hours just can't figure it out | Excel Worksheet Functions | |||
| How do I convert times from hours to minutes? | Excel Discussion (Misc queries) | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Threaded Mode
