You can simply add up your result.

Another way is to find a simple difference first
=B2-A2
and format the cell as custom h:mm or simply h, and then add up the entire
total and format the result also with the same format

- Mangesh



"Jayda" wrote in message
...
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,