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 ?