Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
carl
 
Posts: n/a
Default 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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Niek Otten
 
Posts: n/a
Default

=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   Report Post  
carl
 
Posts: n/a
Default

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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a formula on a time sheet to calculate time in 1/. gschmid Excel Discussion (Misc queries) 2 January 18th 05 02:48 PM
calculate negative or positve difference in time kpmoore Excel Discussion (Misc queries) 2 January 5th 05 02:35 AM
Formula for time? shaggy78 Excel Discussion (Misc queries) 11 December 31st 04 09:13 PM
Calculating time difference Robyn Bellanger Excel Discussion (Misc queries) 2 December 23rd 04 03:29 AM
What is the formula for getting time difference e.g. ("4 hrs 15 m. Sandeep Manjrekar Charts and Charting in Excel 3 December 4th 04 06:18 AM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"