calculating time

  • Thread starter Thread starter Xavie
  • Start date Start date
X

Xavie

Hi,

I have to calculate the following
Employee job in must be 9:00 am, but employee arrived 8.53 am.
Which formula must I use to calculate the 7 min ?
 
Hi,

Start time in A1 and arrival time in b1

=A1-B1

But this will fail if an employee is late so it's best to use

=MAX(A1,B1)-MIN(A1,B1)

Now apply a conditional format to this cell using the formula

=B1>A1
Select red font and if an employee is late it will show up red
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top