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..