Excel Application

I don't remember for sure, and don't have Excel on this computer, but can you just subtract Bn - An? As a second possibility, you might be able to separate the dates and the times and subtract them individually (with some logic for subtracting a greater time from a lesser).

I'll try to play with this next time I use my other computer, with Excel.

Tornado is essentially correct, according to my experiences. What I do for this application is separate the date and time, making sure the time is formatted correctly, then subtract start time from end time. This creates an issue when the duration period crosses midnight, but I solve this by splitting the period by days- to formula should work better with the full date-time format, since the date is stored as a floating point number (the integer part representing the number of days since some starting date, and the decimal part representing some part of 24 hours). The key is making sure the format styles of the source and destination cells are properly set. Note that Excel has a bad habit of auto-formatting cells without your permission, if you make a typing error while trying to enter data (fix this by manually formatting all cells in a column after all the data are entered). If you are importing the data from another application, it is critical that you insure that the original data is in the floating point format, not text strings...

i just subtracted the first from the second, reult in the 'Duration' column, formatted to show hh:mm:ss in 'custom' mode and voila !

i don't know if this is the right way..

I not sure you have made it clear exactly what your looking for so I will try to cover several possibilities.

I assume you have the formula correct and the data is in correct date format. So you have as an example formula in column c2 would be is b2-a2.

I assume you have this correct and what your looking for is is actually the formatting into XXhrs,XXmins is your true question.

Highlight the cells you want and simply go to your menu in excel and choose [Format], then [Cells], then choose [Custom] in the category area, then in 'type' type or copy in the upper box exactly as follows:

[h]"hrs",mm"mins"

hit enter and you are set.

This is the resulting formatting is at the bottom.

Thank you all.

i think you can check the following:

in column C (Duration), Substract Column B from Column A, then apply special format to Column C (in Excel, right click - format cell - Custom - (h):mm:ss - enter, and copy this formula and format to all cells in column C.

Brgds

I really appreciate. Thanks!

Dates in Excel are stored by the program as a Serial number (regardless of its format), which represents the number days since 1900... So you can simply subtract the later date from the earlier date, and it will be right.. .then the hh:mm:ss is treated as a plus or minus to that date.

http://www.cpearson.com/excel/datetime.htm

Chris