how can i add time in excel?

M

Marcus

Does any one know how to make excel add in time format?
Example: it is 6:00 AM in cell A1, it is 3:00 PM in cell A2, i want excel to
give me the total hours worked in cell A3, total hours worked being 9. Is
there a formula to do this??? Please help
 

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

Subtracting time...again 2
Excel: counting times and dates during non-traditional hours 0
TIME CALCULATION 8
Add time when working 3rd shift 0
Extracting just the time portion 6
Calculate elapsed time excluding specific timeframe 10
Time Sum in Excel 1
Excel - Wich Function should I use? 1

Top