Excel 2007 time calculation

J

jtucker

I export time statistics into Excel 2007 so that I can get totals for
multiple entries. The time format is hh:mm:ss and in the hours field it adds
a leading 0. When I set up a SUM calculation the answer is 0. If I click on
each field first which removes the leading 0 the SUM works. I have not found
a way to make this work other than to click on every cell before I add the
formula.
 
P

Pete_UK

Click on an empty cell somewhere and <copy> that cell. Then highlight
all the cells with the time in them and right-click and select Paste
Special | Values (check) | Add (check) | OK then <Esc>.

An alternative way is to use Data | Text-to-columns.

Hope this helps.

Pete
 

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

Top