I am importing from another program into Excel. Anytime I have a time in a column with a 0 in the 2nd hour place it will not add that time in. Example (05:21:32)
A1 10:20:12
A2 05:12:15
A3 10:15:12
Total= 20:35:24
How can I get excel to recognize a time in this format with a zero (05:34:23)?
Thanks for the help!!
Jay
Last edited by jayclinton; 12-17-2008 at 06:24 PM.
Does this work?
=SUMPRODUCT(A1:A3+0)
No it doesn't seem to be adding them all up. I have one tab with all the info imported. On the 2nd tab I am taking the information from certain cells and adding them up here.
A1 25:00:10
A2 05:00:10
A3 25:00:10
A4 30:00:10
This information is taken from tab 1 and looks like this on tab two. My totals never add in any time that has a zero in front.
What result did you get with that formula? What formula were you using before, just SUM?
I assumed that some of the times (those with leading zeroes) were text formatted. My suggestion would cope with that while SUM doesn't
Oh wait I think it did work. Let me get right back to you. Thanks!!
Yes it worked. Great!! Thanks for the help!!!
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks