=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,

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,

=SUMPRODUCT((B2:B20-A2:A20))*24

one step

--
HTH

Bob Phillips

"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,

Why are you using TEXT?

Regards,

Peo Sjoblom

"Jayda" wrote:

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,