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

Completing Formula For Hours Worked 3
Adding Hours 1
Calculate Total hours worked during workdays within given shift time. 2
#VALUE error add'g formulas 1
Calculate OT/TIL hours when 1st 2 hrs are double time, rest are 1: 2
Calculating total amount in a Pivot Table 1
how do I calculate the sum of hours if marked x in a schedule? 2
Keep total of cells in a cell after deleting source data 8

Top