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

R

Ronnie Kray

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

15 minute data to daily data 1
problem with time subtraction 7
Work Hours 1
Total Working hours If 2
Sum Time 7
IF calculation of Time 2
Time sheet 2
Figuring total # of hours between multiple times 5

Top