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

  • Thread starter Thread starter martha
  • Start date Start date
M

martha

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