A huge problem:
I have two times, for example: 2min32sec67hdth & 2min30sec23hdth
How do I calculate the difference between those two?

Please help me, I´m desperate..

One way:

A1: 2:32.67
B1: 2:30.23
C1: = A1 - B1

Format C1 with Format/Cells/Number/Custom mm:ss.00

In article ,
"R-teast Loman" <R-teast wrote:

A huge problem:
I have two times, for example: 2min32sec67hdth & 2min30sec23hdth
How do I calculate the difference between those two?

Please help me, I´m desperate..

In Excel, functions are only able to show seconds as the lowest number. But
there is a way around this.

I took two now functins and changed them to values about 5 seconds apart.
Then I changed them to numbers at 8 decimal places, so they look like this.

C1 = 38281.4276020833000

C3 = 38281.4276678241000

The number after the decimal is the time (as a percentage of a 24 hour day,
so the above numbers say we are about 42% through the day, so it's about
10:08)

In C5, if you take C3 - C1 you get 0.0000657407363
=second(C5) -- 6 (or 6 seconds)

another way to do it is with calculations like this:

=($C$3-$C$1)*24*60*60 (24 hours in a day, 60 minutes in an hour, 60 seconds
in a minute) or =($C$3-$C$1)*86400 (86400 seconds in 24 hours)

this results in 5.679999617860 (or 5 seconds and 68 hundreths)

I hope that helps.

Joe V.



"R-teast Loman" wrote:

A huge problem:
I have two times, for example: 2min32sec67hdth & 2min30sec23hdth
How do I calculate the difference between those two?

Please help me, I´m desperate..

Not true - you can format cells to display tenths, hundredths or
thousandths of a second and functions will calculate and display
correctly.

Format/Cells/Number/Custom hh:mm:ss.000


In article ,
"joev7777" wrote:

In Excel, functions are only able to show seconds as the lowest number. But
there is a way around this.

Thanks JE, didn't know that!

Joe V.

"JE McGimpsey" wrote:

Not true - you can format cells to display tenths, hundredths or
thousandths of a second and functions will calculate and display
correctly.

Format/Cells/Number/Custom hh:mm:ss.000


In article ,
"joev7777" wrote:

In Excel, functions are only able to show seconds as the lowest number. But
there is a way around this.

On Thu, 21 Oct 2004 09:24:55 -0700, "R-teast Loman" <R-teast
wrote:

A huge problem:
I have two times, for example: 2min32sec67hdth & 2min30sec23hdth
How do I calculate the difference between those two?

Please help me, I´m desperate..

=("0:"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"min"," :"),"sec","."),"hdth",""))-
("0:"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"min",": "),"sec","."),"hdth",""))

You will need to format this as time; perhaps:

[h]:mm:ss.00


--ron

If that's how you have entered the times, that's your "huge" problem. Ron has
given you a formula to convert to true Excel times, so you can do math on
them.

On Thu, 21 Oct 2004 09:24:55 -0700, "R-teast Loman" <R-teast
wrote:

A huge problem:
I have two times, for example: 2min32sec67hdth & 2min30sec23hdth
How do I calculate the difference between those two?

Please help me, I´m desperate..