|
Excel Calculation with Time
I'm trying to have a cell say that someone is late or on time. I have a cell
that has subtracted the actual punch in time from the call time (difference). I'd like for my 'on time or late' cell to automatically say that someone is late if my difference cell is greater than 7 minutes (0:07), if it's less than or equal to 7 minutes, then it would say on time. I'm having trouble getting the calculation to work. |
Excel Calculation with Time
=IF(call_time-punch_in_time<=--"00:07","On Time","Late")
-- __________________________________ HTH Bob "MadBrotherMan" wrote in message ... I'm trying to have a cell say that someone is late or on time. I have a cell that has subtracted the actual punch in time from the call time (difference). I'd like for my 'on time or late' cell to automatically say that someone is late if my difference cell is greater than 7 minutes (0:07), if it's less than or equal to 7 minutes, then it would say on time. I'm having trouble getting the calculation to work. |
| All times are GMT +1. The time now is 04:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com