Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fun with Time values
Hello all, The boss gave me a new one today, and there is one formula I can not get my head around. Here is the situation: In part of the Excel sheet, I have a colum listing scheduled delivery times for various locations. These Time Values are static, i.e. non-changing. Each colum to the right of these projected Time Values will contain Actual Delivery times. One colum per each day of the month for Actual Delivery times. What I need to do with these values is this: 1) Automatically highlight any Delivery Time that exceeds the projected Delivery Time by 1 hour. This I have done with Conditional Formatting. No problems there 2) I need to automatically output -only- the cell values from above to a second page in the workbook. This is the one I am having issues with, as the values must show up on page 2 of the work book automatically, but only if they meet the criteria listed under #1 above. The boss will look at me as if I am sprouting two heads if I say anything about "cutting" or "pasting". Some ideas would be great. I'd be happy to provide any more details if needed. Formula syntax is my biggest headache, so please be spacific on that. Thank you in advance for your time. -Wisper -- wisperc ------------------------------------------------------------------------ wisperc's Profile: http://www.excelforum.com/member.php...o&userid=30123 View this thread: http://www.excelforum.com/showthread...hreadid=498118 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fun with Time values
=(NF7(M7+"1:0"),N7,0) all i needed -- wisperc ------------------------------------------------------------------------ wisperc's Profile: http://www.excelforum.com/member.php...o&userid=30123 View this thread: http://www.excelforum.com/showthread...hreadid=498118 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
time sheet | Excel Discussion (Misc queries) | |||
need help with - time values... | Excel Discussion (Misc queries) | |||
Time Values | Excel Discussion (Misc queries) | |||
How do you find the difference between two time values when one i. | Excel Discussion (Misc queries) |