=Text(b2-A2,"h") hours between 2 times, what do I do for 10 times

[Jayda]

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,

 

[Mangesh]

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

 

[Bob Phillips]

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

one step

 

[Peo Sjoblom]

Why are you using TEXT?

Regards,

Peo Sjoblom