ExcelBanter - time window calculation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - time window calculation (https://www.excelbanter.com/excel-worksheet-functions/270726-re-time-window-calculation.html)

SteveR

time window calculation

I goofed up my question. You are right the data is in column A. The intermediate formula I am trying to eliminate "mod(a1),1" is in Column M.

joeu2004

time window calculation

On Mar 7, 3:31*pm, SteveR wrote:
I goofed up my question. *You are right the data is in
column A. * The intermediate formula I am trying to
eliminate "mod(a1),1" *is in Column M.

I presume you do understand that you simply use my suggestions, but
substitute A:A, A1 and A1:A250 where I wrote M:M, M1 and M1:M250.

All times are GMT +1. The time now is 09:54 AM.