Expert: Richard Rost - 10/30/2009

Question
Hi!, hope you can help, i am calculating time sheets, times in and out, on a daily basis. I need to be able to calculate the sum of each week, from hours worked each day, in terms of hours worked (hh:mm).

I especially need to see results if over 24 hours to be shown, for example as 26 hours 35 minutes, and not 2:35 as the result i am currently getting.

Thanks.

Answer
This tutorial should answer your question:

There are many different techniques in Excel you can use to break apart dates or times into their component parts, add or subtract dates, and figure out how much time is elapsed between two dates.

Read this free tutorial from my web site that explains how to work with adding dates and times in Excel:

http://599cd.com/tips/excel/adding-dates-times/?key=AllExperts

I also have this FREE video tutorial that shows you how to get month names (like "September") from dates:

http://599cd.com/tips/excel/month-names/?key=AllExperts

I spend a LOT of time talking about dates and times in my full Excel tutorials:

http://599cd.com/Excel?key=AllExperts

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT EXCEL VIDEO TUTORIAL. Go to http://www.599cd.com/Excel/AllExperts


Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Excel Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

I hope this information helps to solve your problem. If there is ANY REASON why you won't give me a RATING of 10 please let me know so I can improve upon my answers in the future. Thank you!

Sign up for my FREE NEWSLETTER with lots of TIPS and TRICKS. Visit http://www.599cd.com/MailingList?key=AllExperts

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts