Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
So, cell A1 contains a fixed time in the format of "hh:mm:ss",
and cell A2 contains a fixed data in the format of "mm/dd/yy". Users will be entering a time into cell B1 and a date into cell B2. How can I determine if the times and dates entered into cells B1 and B2 are greater than the fixed time and date in cell A1 and A2 by more than 24 hours? I hope that makes sense. I'm just looking for code to do the calculation. Thank you! Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I calculate total pay from pay rate times hours and minutes | Excel Discussion (Misc queries) | |||
Calculate total for rate times hours in Excel? | Excel Discussion (Misc queries) | |||
Calculate hours between to separate dates and times | New Users to Excel | |||
How do I calculate dates and times, w/answer of days & hours | Excel Worksheet Functions | |||
Calculate the number of hours between two dates and times | Excel Programming |