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

Best Black Friday 2014 tech deals: Get bargains on smartphones, tablets, laptops and more

IDG UK Sites

What the Internet of Things will look like in 2015: homes will get smarter, people might get fitter

IDG UK Sites

See how Trunk's animated ad helped Ade Edmondson plug The Car Buying Service

IDG UK Sites

Yosemite tips for beginners: Complete Guide to OS X Yosemite