| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Time / Formula to look at time difference
My time data looks like this:
COLA COLB 93357 93404 Is there a formula that i can use in B2 that will tell me the difference between the 2 times (00:00:7 hours:min:seconds) ? Thank you in advance. |
|
#2
|
|||
|
|||
|
I hope you mean 00:00:47!
=TIME(0,0,A2-A1) -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... My time data looks like this: COLA COLB 93357 93404 Is there a formula that i can use in B2 that will tell me the difference between the 2 times (00:00:7 hours:min:seconds) ? Thank you in advance. |
|
#3
|
|||
|
|||
|
=TIME(INT(A2/10000),INT(MOD(A2,10000)/100),MOD(A2,100))-TIME(INT(A1/10000),INT(MOD(A1,10000)/100),MOD(A1,100))
-- Kind Regards, Niek Otten Microsoft MVP - Excel "carl" wrote in message ... My time data looks like this: COLA COLB 93357 93404 Is there a formula that i can use in B2 that will tell me the difference between the 2 times (00:00:7 hours:min:seconds) ? Thank you in advance. |
|
#4
|
|||
|
|||
|
no. i meant 7 seconds.
"Bob Phillips" wrote: I hope you mean 00:00:47! =TIME(0,0,A2-A1) -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... My time data looks like this: COLA COLB 93357 93404 Is there a formula that i can use in B2 that will tell me the difference between the 2 times (00:00:7 hours:min:seconds) ? Thank you in advance. |
|
#5
|
|||
|
|||
|
Hi Carl
but then please explain HOW you come to this result looking at your example data??? -- Regards Frank Kabel Frankfurt, Germany carl wrote: no. i meant 7 seconds. "Bob Phillips" wrote: I hope you mean 00:00:47! =TIME(0,0,A2-A1) -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... My time data looks like this: COLA COLB 93357 93404 Is there a formula that i can use in B2 that will tell me the difference between the 2 times (00:00:7 hours:min:seconds) ? Thank you in advance. |
|
#6
|
|||
|
|||
|
Hi
sorry, forget my post. Use Niek's answer -- Regards Frank Kabel Frankfurt, Germany carl wrote: no. i meant 7 seconds. "Bob Phillips" wrote: I hope you mean 00:00:47! =TIME(0,0,A2-A1) -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... My time data looks like this: COLA COLB 93357 93404 Is there a formula that i can use in B2 that will tell me the difference between the 2 times (00:00:7 hours:min:seconds) ? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
| Formula for time? | Excel Discussion (Misc queries) | |||
| Calculating time difference | Excel Discussion (Misc queries) | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Linear Mode
