Sum of Time Worked

**Zimmy242** · 03-14-2023, 04:50 PM

I'm trying to Sum the total time worked on a project in L10, but the Sum function isn't working. Can someone help me with this? I'm sure it's something silly.

**CARACALLA** · 03-14-2023, 04:59 PM

G3=IF($C3<>"",TEXT($F3-$E3,"h:mm")+0,"")

Copy down

=SUM(G3:G100)

custom format [h]:mm:ss

Sum of Time Worked

LinkBack

Thread Tools

Rate This Thread

Display

Sum of Time Worked

Re: Sum of Time Worked

Thread Information

Users Browsing this Thread

Similar Threads

Calculating rostered time worked or rostered time not worked after a given amount of hours

How to calculate time worked: Start time, end time, lunch break

[SOLVED] Calculating multiple pay rates based on time of day worked, not number of hours worked

[SOLVED] Summing Column Find Out How Much Time Worked Using Date Ranges & Person Worked

[SOLVED] Punch-Time Data. Calculating # of hours worked and # of hours worked alone per shift.

Calculating basic hours worked, between a time range and premium hours worked

Excel 2007 : Calculating basic hours worked, between a time range and premium hours worked

Bookmarks

Bookmarks

Posting Permissions