| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I compare two times to see if one is "late" or "on time"?
I need to compare project 'start time' to project 'deadline time' for daily
projects. The deadline time for Sunday through Friday is the same, 12:00 AM, but on Saturday the deadline is 12:15 AM. I need to be able to show if the project is 'on time'--that is on or before the deadline time-- or 'late', that is after the deadline time. Any help? |
|
#2
|
|||
|
|||
|
=IF(A2IF(WEEKDAY(TODAY())=6,TIME(12,15,0),TIME(12 ,0,0)),"Late","OK")
where A2 is the start time -- HTH Bob Phillips "AuditorGirl" wrote in message ... I need to compare project 'start time' to project 'deadline time' for daily projects. The deadline time for Sunday through Friday is the same, 12:00 AM, but on Saturday the deadline is 12:15 AM. I need to be able to show if the project is 'on time'--that is on or before the deadline time-- or 'late', that is after the deadline time. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL - I need to compare times to the hundredth of a second | Setting up and Configuration of Excel | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
| Is there a way to compare 2 spreadsheets with Excel? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
| Compare Times | Excel Worksheet Functions | |||
Linear Mode
