totaling time in 2 cells w/ total of hours worked in 3rd
 

I am putting together a worksheet and having diff. w/ figuring out how to
total 2 cells in the same row w/ getting the number of total hours worked in
the last cell.


so someone works from 7:30am to 3:30pm I want to total this and put total
hours in 3 cell how do I do this.

totaling time in 2 cells w/ total of hours worked in 3rd
 

as long as the times are in actual time format: 7:30 AM and 3:30 PM, do
=(B2-A2)*24 and format as Number. This does NOT take into account lunch, so
may need to add in a -1 or -:30

"martha" wrote:

I am putting together a worksheet and having diff. w/ figuring out how to
total 2 cells in the same row w/ getting the number of total hours worked in
the last cell.


so someone works from 7:30am to 3:30pm I want to total this and put total
hours in 3 cell how do I do this.

totaling time in 2 cells w/ total of hours worked in 3rd
 

Col A Col B Col C
7:30 AM 3:30 PM =B1-A1

and custom format the formula cell to [h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"martha" wrote:

I am putting together a worksheet and having diff. w/ figuring out how to
total 2 cells in the same row w/ getting the number of total hours worked in
the last cell.


so someone works from 7:30am to 3:30pm I want to total this and put total
hours in 3 cell how do I do this.