Fred, you have helped me but there is still a a problem when subtracting
date and time. It gives me a 1 in the month value when it is the same month
and there should be a 00 there. I have typed my method and following my
method I did find another example but it is only for hours.
The only thing I did differently was put it in the format of mm/dd/yy
hh:mm:ss however when I have 8/21/2009 11:00:58 PM - 8/1/2009 11:00:50 PM
Typed in the formula representing cells =B8-B7 It gives me this value for
elapsed time 01/12/00 16:45:32 there should not be a 1 in the mm value.
Fred I found this instruction in excel but do not think that it will solve
my problem.
Calculate elapsed time (subtract time)
Elapsed time is the difference between two times. Suppose that you want to
calculate the elapsed time of a practice marathon run that you started at
10:24:00 AM and that ended at 2:13:36 PM, measured to the second.
Do the following:
In cell A1 (or any other cell), type the end time. For example, type
10:24:00 AM.
In cell A2 (or any other cell), type the start time. For example, type
2:13:36 PM.
Tip Make sure that you include a space between the minute value and "AM"
or "PM."
In cell A3, type =A2-A1.
On the Home tab, in the Cells group, click Format, and then click Format
Cells.
In the Format Cells dialog box, click the Number tab.
Under Category, click Custom.
In the Type box, type [h]:mm:ss.
Tip You can also show the results in minutes by setting the format to
[m]:ss.
Click OK.
In cell A3, Excel displays 3:49:36 (or 229:36 if you used the format [m]:ss).
Top of Page
Fred I found this instruction.
Calculate elapsed time (subtract time)
Elapsed time is the difference between two times. Suppose that you want to
calculate the elapsed time of a practice marathon run that you started at
10:24:00 AM and that ended at 2:13:36 PM, measured to the second.
Do the following:
In cell A1 (or any other cell), type the end time. For example, type
10:24:00 AM.
In cell A2 (or any other cell), type the start time. For example, type
2:13:36 PM.
Tip Make sure that you include a space between the minute value and "AM"
or "PM."
In cell A3, type =A2-A1.
On the Home tab, in the Cells group, click Format, and then click Format
Cells.
In the Format Cells dialog box, click the Number tab.
Under Category, click Custom.
In the Type box, type [h]:mm:ss.
Tip You can also show the results in minutes by setting the format to
[m]:ss.
Click OK.
In cell A3, Excel displays 3:49:36 (or 229:36 if you used the format [m]:ss).
Top of Page
I changed the format I want to display the difference in dd/mm/yy hh/mm/ss
The cell values are
In cell A1 (or any other cell), type the end time. For example, type
10:24:00 AM.
In cell A2 (or any other cell), type the start time. For example, type
2:13:36 PM.
Tip Make sure that you include a space between the minute value and "AM"
or "PM."
In cell A3, type =A2-A1.
On the Home tab, in the Cells group, click Format, and then click Format
Cells.
In the Format Cells dialog box, click the Number tab.
Under Category, click Custom.
In the Type box, type [h]:mm:ss.