total Hours Worked for week PS thx for the formulars everyone!

G

Guest

Mon Tue
A1 B1
7:00 7:00 Start Time

A2 B2
17:00 16:45 Finish Time

A3 B3
10:00 9:45 Total Hours worked

How do i add A3 & B3 to show 19 Hours & 45 Mins
 
T

T. Valko

I don't know which of the other formulas you used but this one will (should)
work:

=SUM(A3:B3)

Format as [h]:mm
 

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

Figure out the hours worked for the week 2
Work Hours 1
Total Working hours If 2
WORK HOURS DIFFERENCE BETWEEN TWO DATES 12
Sum Time 6
Adding time 5
Calculating a colmun to total a 40 hour work week 3
Figuring total # of hours between multiple times 5

Top