How to count seconds?

[Quinn28]

Hello I have this create date: 12/22/2011 9:31 and fixed date: 12/23/2011 12:34

I want to know how many seconds does it takes to from create date to fixed date.

I tried: 12/23/2011 12:34 - (minus) 12/22/2011 9:31
Result is 3:02:38, hr:mm:ss

Is this correct? 3 hours and 2 minutes and 38 seconds? I just converted the hour/minutes to seconds and add all time. I end up to 10958 seconds.


Thanks in advance!

[OnErrorGoto0]

Assuming the dates in A1 and B1, then use
=A1-B1 and use a custom number format (in the format cell dialog) of [ss]
You should get around 97380 depending on what the seconds values of your times are, since you have over a day difference.

[Quinn28]

thanks! []sign surely helps

[Quinn28]

Hi Rory, can you help me with another formula?

I cant use ISERROR for this formula =IF(V2=1,M2,"").

Thanks!

[zbor]

For new question open new thread please.

[Quinn28]

oopppps sorry! sure