ExcelBanter - Worker's breaks punch in/out verification

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Worker's breaks punch in/out verification (https://www.excelbanter.com/excel-discussion-misc-queries/131509-workers-breaks-punch-out-verification.html)

kdsteff

Worker's breaks punch in/out verification

How can a time function be used to output the current time when an employee
enters the time in and out from breaks? This would be done using 2
worksheets so an employee wouldn't know. Is there a function like NOW() that
gives the current time without changing? =IF(A170,NOW(),"") I was just
trying to use a simple function.

All times are GMT +1. The time now is 07:19 PM.