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
From United States, Harrisburg
K
From United States, Harrisburg
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
1using "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
Please chk this link; with this you should be able to do on ur own:
https://www.citehr.com/download-list.php?query=excel
From India, Hyderabad
https://www.citehr.com/download-list.php?query=excel
From India, Hyderabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
EXCEL FORMULA.xls