Excel Calculation with Time

  • Thread starter Thread starter MadBrotherMan
  • Start date Start date
M

MadBrotherMan

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting for times 1
Conditional Formatting Times 1
If Formula 15
Conditional Format over Date Range 3
Calculating Time Spans 2
Time Calculation 2
Time remaining until event 2
Calculate times between dates and times in Excel 1

Back
Top