Calculate the number of seconds between two times

B

Budda Belly

I need to calculate how many seconds are between two times, e.g. 8:08 AM
start time and 8:44 AM stop time so I can use the result in a formula.

The start and stop times are in neighboring columns.

The formula would be result= number of counts / (Stop time-Start time) in
seconds to give me a result in counts/second.
 
R

Ron Rosenfeld

On Tue, 1 Jun 2010 13:24:01 -0700, Budda Belly <Budda
I need to calculate how many seconds are between two times, e.g. 8:08 AM
start time and 8:44 AM stop time so I can use the result in a formula.

The start and stop times are in neighboring columns.

The formula would be result= number of counts / (Stop time-Start time) in
seconds to give me a result in counts/second.

=StopTime - StartTime

You can custom format the cell with this formula a and it will
display the number of seconds.

Or to generate a value that can be used in a subsequent formula, since
Excel stores times as fractions of a day, multiply your result by
86400 and format as General or Number.

e.g: =NumberOfCounts/((StopTime-StartTime)*86400)
 
R

Roger Govier

Hi
=(B1-A1)*84600
Format the cell with the formula as General or Number

XL stores times as fractions of a day (24 hours)
To get to Seconds therefore you need to multiply by 24*60*60 or 84600

--
-------
Regards
Roger Govier

Budda Belly said:
I need to calculate how many seconds are between two times, e.g. 8:08 AM
start time and 8:44 AM stop time so I can use the result in a formula.

The start and stop times are in neighboring columns.

The formula would be result= number of counts / (Stop time-Start time) in
seconds to give me a result in counts/second.

__________ Information from ESET Smart Security, version of virus
signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top