Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
061006 Date vs Time of Day, if x hrs (8-4) divide by?..
hi, need help on what would be best idea for determining if daily values are at expect levels, for each line, in reference to the time of day. all values in column are updated at the same time / simultaneously. i.e. guesse could have 1 NOW time stamp, in one cell. trying to figure out how to setup example of other date formula for if within 10 days: =IF(TODAY()DATE(MID(T9,2,2)+100,MID(T9,4,2),MID(T 9,6,2)-(10+1)),"d", maybe Need for hours: 8am - 4pm, if dividing by even hours (or maybe something more dynamic? / to minutes). thanks! have previous column, of previous day total, but more to point: have fixed cells at top for desired levels (THAT CAN DIVIDE in Equal Levels). e.g.: $CI$7 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
p.s. need formula for weekdays / not holidays, not sure how to use WORKDAY?
if applies.. "nastech" wrote: 061006 Date vs Time of Day, if x hrs (8-4) divide by?.. hi, need help on what would be best idea for determining if daily values are at expect levels, for each line, in reference to the time of day. all values in column are updated at the same time / simultaneously. i.e. guesse could have 1 NOW time stamp, in one cell. trying to figure out how to setup example of other date formula for if within 10 days: =IF(TODAY()DATE(MID(T9,2,2)+100,MID(T9,4,2),MID(T 9,6,2)-(10+1)),"d", maybe Need for hours: 8am - 4pm, if dividing by even hours (or maybe something more dynamic? / to minutes). thanks! have previous column, of previous day total, but more to point: have fixed cells at top for desired levels (THAT CAN DIVIDE in Equal Levels). e.g.: $CI$7 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
change date based on time | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) |