If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subtracting Times with Strang Format
My time data looks like this
2/10/2005 4:02:38 PM 2/10/2005 4:03:45 PM Is there a formaula I can use to subtract the two times ? Thank you in advance. |
#2
|
|||
|
|||
One way:
Assuming your data are in A1:A2: A3: =A2-A1 Format A3 as Format/Cells/Number/Custom [h]:mm:ss In article , "carl" wrote: My time data looks like this 2/10/2005 4:02:38 PM 2/10/2005 4:03:45 PM Is there a formaula I can use to subtract the two times ? Thank you in advance. |
#3
|
|||
|
|||
thanks. this did not work. i think my data is uniquely formated. regards.
"carl" wrote: My time data looks like this 2/10/2005 4:02:38 PM 2/10/2005 4:03:45 PM Is there a formaula I can use to subtract the two times ? Thank you in advance. |
#4
|
|||
|
|||
On Mon, 14 Feb 2005 08:17:02 -0800, "carl"
wrote: My time data looks like this 2/10/2005 4:02:38 PM 2/10/2005 4:03:45 PM Is there a formaula I can use to subtract the two times ? Thank you in advance. With the data in A1 and A2, the formula would be =A2-A1 Format the result something like [h]:mm:ss --ron |
#5
|
|||
|
|||
On Mon, 14 Feb 2005 09:19:04 -0800, "carl"
wrote: thanks. this did not work. i think my data is uniquely formated. regards. There's nothing particularly unique about your format. It is a standard Excel format. What does "not work" mean? Do you get a blank cell? crash Excel? some error message? Incorrect result? Did you enter the data manually, or import if from someplace? If you imported or copied it from someplace, what was the source? If your data is in A1, what is the result of the formula =ISTEXT(A1)? --ron |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom number format | cac | General Discussion | 1 | January 24th, 2005 05:49 PM |
Forcing Outlook to reply to HTML emails using plain text format | none | General Discussion | 1 | January 18th, 2005 11:29 PM |
Find/Replace text, NOT format!!! | HennyBogan | General Discussion | 5 | June 21st, 2004 08:45 PM |
subtracting multi-valued times in one cell | Scott | Worksheet Functions | 2 | February 9th, 2004 01:49 PM |