Computer hardware and software
How do I create excel hourly timesheet which alerts when hours are left out of 24 hr shift?
Question : How do I create excel hourly timesheet which alerts when hours are left out of 24 hr shift?
I’m tracking several workers over a 24 hour billing period for one client. I need to know of any hours that are left out of the 24 hours the workers are reporting.
timesheet
Best answer:
Answer by expletive_xom
i guess you can add up the hours and see if the hours equals 24.
it really depends on how your sheet is setup.
You would add an if statement that checks if your condition has been met
=IF(SUM(A1:A3)<>24,”ALERT: Not 24 Hours”,”")
It will type this message until it equals the 24 hours. Perhaps you can make it contingent on end of day reached by using a nested if statement which has a cell that says x here if end of day
=IF(D1=”x”,IF(SUM(A1:A3)<>24,”ALERT: Not 24 Hours”),”") or have it check automatically on some other situation met perhaps a date field changing.