how to calculate seconds elapsed between two moments?

W

Wim

I need the number of seconds between two moments.
A1: 14:10:00
A2: 14:15:00

Difference is 5 minutes = 300 seconds.

What formula(/cell format) do I need to use to get the number 300 in
the result cell? When I use the formula A2-A1 I get a
00:05:00 (in time format)
0.003472222 (in General format)

When I use Second(a2-a1) I get 0

how to get 300 ??

Wim
 
R

RagDyeR

Custom format the cell containing the formula to:

[ss]

The square brackets prevent the seconds from rolling over to minutes and /
or hours when they're greater then 60.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I need the number of seconds between two moments.
A1: 14:10:00
A2: 14:15:00

Difference is 5 minutes = 300 seconds.

What formula(/cell format) do I need to use to get the number 300 in
the result cell? When I use the formula A2-A1 I get a
00:05:00 (in time format)
0.003472222 (in General format)

When I use Second(a2-a1) I get 0

how to get 300 ??

Wim
 
W

Wim

brilliant. No reference to this [ ] format in the MS Excel help files!
Strange.
Thanks a million.
Wim
 
W

Wim

However, it is just *formatting*,not the real number, hence giving a
problem wen referring to this cell in another cell. I rather use the
formula Minute(a2-a1)*60 + second(a2-a1)
 
M

Mangesh Yadav

format the cell as


Format > Cells > choose custom and enter the above format

Mangesh
 
Top