Calculate the number of seconds between two times
in [Functions]
|
From: Budda Belly Budda on 1 Jun 2010 16:24 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.
From: Ron Rosenfeld on 1 Jun 2010 16:56 On Tue, 1 Jun 2010 13:24:01 -0700, Budda Belly <Budda Belly(a)discussions.microsoft.com> wrote: >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 [s] 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)
From: Roger Govier on 1 Jun 2010 17:06 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" <Budda Belly(a)discussions.microsoft.com> wrote in message news:C195F6C5-4A04-46F0-9872-9FB06EC6A472(a)microsoft.com... > 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
|
Pages: 1 Prev: Filter zeros from two columns, maybe on different rows Next: Recalculate the Formula |