You are here:
Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.
Have been working with Excel for about 15 years primarily in accounting and financial areas.
BA, CPA
Chan I am not sure what you mean by your first question. Second question--If you make your list include more rows than what is needed your list, and leave the cells blank that you are not using then
Laura Time is always tricky to work with because of the hours days, etc are not easy for us to convert mentally to what is needed for excel to do the calculation correctly. It becomes easier if you
Pravin In your first question I am not sure if you want the numbers to be horizontal or verticle within the cell or horizontal from left to right within the same row, but in different cells, or--- verticle
Joseph You are correct, excel will recognize the 10:30-3:30 as text and won't calculate it as a number. There are a couple of possibilities, What I would do is create a time in and a time out column
Zhesketh Check the data in cells B1 and B10 and in your formula cell. Excel is probably reading one of these as text and therefore can't do a calculation so it is giving you the VALUE error. Also
Answers by Expert:

©2012 About.com, a part of The New York Times Company. All rights reserved.