Adding Time

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

Is there a way to enter time in cells (e.g. 2h 20m 34s) so that they can be
added? I am using Excel 2007
Thanks
 
Many thanks!


Square Peg said:
Is there a way to enter time in cells (e.g. 2h 20m 34s) so that they can
be
added? I am using Excel 2007
Thanks
Click to expand...

If you just enter them as "2:20:34", Excel will convert them to a time
and you can perform arithmetic on them.


A B [Formula in B]
1 02:20:34 02:20:34 [=A1]
2 03:15:20 05:35:54 [=B1+A2]
3 01:15:06 06:51:00 [=B2+A3]
Click to expand...
 
Just a note to remember...Excel keeps track of time in days. If the result is
in general/number format, it will be the number of days.

-rv
 

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

Nested If statement -- please help :) 8
MOV to mpeg-4 - Views only top10% of screen - newbie ? 12
1d 2h 3m 3
Security flaw found in Microsoft Word will be patched today 5
surface area optimization 1
Linking Worbooks 1
How to enter start and end date/time in excel based on some specific value. 7
Formatting Cells - Hex Values 3

Back
Top