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

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.
 
S

Sean Timmons

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arriving at totals 2
Completing Formula For Hours Worked 3
Excel: counting times and dates during non-traditional hours 0
computations at odd locations 2
Calculate total for rate times hours in Excel? 3
Calculating total amount in a Pivot Table 1
If Formula 2
How do you limit the total allowed for a group of cells? 1

Top