I subtract 1:0:26 from 1:34:54 and get 12:34:38 AM - I want total.
 

I need help with an Excel formula. I am tracking total video time so when I
subtract the length of the video, my return value is coming back as time of
day. Here it is: Cell D3 = Start Time = 1:0:26 (the cell is formatted
Custom [h]:mm
Cell E3 = Finish Time = 1:34:54 (the cell is formatted Custom [h]:mm

When I do the following formula: =E3-D3, the return value is 0:34:28 (which
is what I want)

When I copy and paste special, values - it converts this to time of day
12:34:28 AM - Question: How do I keep the return value 0:34:28 ?

I have XL2003, so I have the option of "Value and number
formats" under Edit Paste Special. If you don't have
that option, after doing Edit Paste Special Value,
repeat the process and select Formats.

HTH
Jason
Atlanta, GA

-----Original Message-----
I need help with an Excel formula. I am tracking total
video time so when I
subtract the length of the video, my return value is
coming back as time of
day. Here it is: Cell D3 = Start Time = 1:0:26 (the
cell is formatted
Custom [h]:mm
Cell E3 = Finish Time = 1:34:54 (the cell is formatted
Custom [h]:mm

When I do the following formula: =E3-D3, the return
value is 0:34:28 (which
is what I want)

When I copy and paste special, values - it converts this
to time of day
12:34:28 AM - Question: How do I keep the return value
0:34:28 ?
.

Do a 2nd PasteSpecial, selecting Formats this time.

On Fri, 11 Feb 2005 11:37:07 -0800, "Kristie"
wrote:

I need help with an Excel formula. I am tracking total video time so when I
subtract the length of the video, my return value is coming back as time of
day. Here it is: Cell D3 = Start Time = 1:0:26 (the cell is formatted
Custom [h]:mm
Cell E3 = Finish Time = 1:34:54 (the cell is formatted Custom [h]:mm

When I do the following formula: =E3-D3, the return value is 0:34:28 (which
is what I want)

When I copy and paste special, values - it converts this to time of day
12:34:28 AM - Question: How do I keep the return value 0:34:28 ?