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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top