I just entered a bunch of Time in EXCEL 2010, and I think I used the wrong formatting option. Right now I have 3:47:00 in my Column, which is supposed to be in minutes and seconds. So my question is, can I convert the existing data into the right format so when I add it up, it will add up to the correct amount of hours? I started re-entered the time using leading zero's but it's going to take me a while. Wanted to see if I can use what I already have. If I have to retype, is there a format I can use where I won't have to type in the leading zeros?
Bookmarks