Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ? |
#2
|
|||
|
|||
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 ? . |
#3
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|