Excel Formula To Show "late" Or "on-time"

Kfanella
I am doing a VERY basic spreadsheet to show if employees are late, on time or early based on a date. (Not by the minute or hour) I know it sounds strange, but that's what I need. I have a column for the date that the employee should show up and then a column for the date that the employee actuall showed up and then a status column. How do I get the status column to fill in "Late", "On-Time" or "Early" based on the dates? Any help would be greatly appreciated. Doing it manually is a pain!
K
velarun
hi
using "IF" function, you can get the status
in the worksheet select Insert, Function, IF
define the condition and the reqd output
if u still cant get it done, post ur xl file in this cite
-vellayan
chennai.ibrahim
Please chk this link; with this you should be able to do on ur own:
https://www.citehr.com/download-list.php?query=excel
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute