Subtracting Hours

[Kerri55]

This question is similar to the business days question, in that, I need to subtract one time from another time to get the amount of hours that has past. This will be used for keeping track of employees time.
Also, I would like to be able to enter a start time and have a formula/function to figure and end time, based on an eight hour day.

[Skyhook]

Kerri try these formulas. The first formula is for total hrs. and the second is for total hrs minus a lunch break.

=(D10-C10+(D10
=ROUNDDOWN(F10-E10*24,2)

[Yogi Anand]

On 2002-04-11 07:14, Kerri55 wrote:
This question is similar to the business days question, in that, I need to subtract one time from another time to get the amount of hours that has past. This will be used for keeping track of employees time.
Also, I would like to be able to enter a start time and have a formula/function to figure and end time, based on an eight hour day.

for the first one, let us say start time is 8:00 am in cell A2, end time is 5:00 pm in cell B2, then your formula would be
=B2-A2 ... and formatted as [h]:mm:SS would give you 9:00:00

for the second part, let us say you r start time is 8:00 in cell A4, then your formula would be
=A4+8/24 ... formatted as time hh:mm pm would give 4:00 pm

HTH