Prev: EXCEL 2003 - SUBTOTALS
Next: How can I set the show/hide default for comments in Excel?
From: Xavie on 25 Mar 2010 11:41
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 ?
From: Eduardo on 25 Mar 2010 11:54
Hi,
take a look at CPearson web has everything related to timesheet

http://www.cpearson.com/excel/overtime.htm

"Xavie" wrote:

> 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 ?
From: Mike H on 25 Mar 2010 12:00
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.


"Xavie" wrote:

> 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 ?
 | 
Pages: 1
Prev: EXCEL 2003 - SUBTOTALS
Next: How can I set the show/hide default for comments in Excel?