Calculate the number of seconds between two times

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

 

[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

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