MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time


Posted by Cynthia on September 25, 2001 9:45 AM

I want to do a worksheet for the hours my employees work. I will enter the time they start in one cell and enter the time they quit in another cell. The last cell will have the total amount they worked for that day. At the end of this column, I want to add all the hours they worked in one week.

Can you tell me what the formula will be?

Thanks
Cynthia


Posted by Aladin Akyurek on September 25, 2001 10:02 AM

Cynthia,

If A1 houses the start time and B1 the end time,

=B1-A1

will give you the amount of time worked.

You can just sum the day amounts by

=SUM(Range)

Range houses the daily amounts.

The cell of the SUM formula must be custom formatted as

[h]:mm

Aladin