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.