| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time window calculation | Excel Worksheet Functions | |||
| Establishing a Time Window | Excel Worksheet Functions | |||
| Complex Time Window / date based calculation | Excel Worksheet Functions | |||
| The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
| Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
Linear Mode
