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.
