We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel Formula ~ Please


wee eddie

Likes # 0

I am recording Daily Hours worked in the following way: B1-A1=C1

Where A & B are the Start and Finish Times and C is the number of Hours Worked. These are in the Format 00:00:00 which gives a total of Daily Hours Worked in the Format 00:00:00

The problem: How do I add these up, to give a Weekly Total of Hours Worked.

Like this post
lotvic

Likes # 0

I think you need VoG™ Have a look at MrExcel forum ClickHere

Like this post
wee eddie

Likes # 0

Bump!

Like this post
AroundAgain

Likes # 0

Hi Wee Eddie

I've been following this thread but thought lotvic (post Oct 31, 11.40) had come up with the formula you needed.

I have re-read your post following that one but am not sure what else you are trying to achieve.

Perhaps you could elaborate?

Cheers

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Moto G2 (2014) vs Moto E comparison review: New Moto G is worth the extra cash

IDG UK Sites

Is Apple losing confidence in itself?

IDG UK Sites

Oculus Rift 'Crescent Bay' prototype hands-on: it's an amazing experience

IDG UK Sites

How (and where) to buy an iPhone 6 or iPhone 6 Plus in the UK. Plus: What to do if you pre-ordered...