=A5-A2-(A4-A3)

meaning

End-Start-(LunchIn-LunchOut)

format result as hh:mm


--

Regards,

Peo Sjoblom

"Sharmila" wrote in message
...
I have to calculate the hours for my employees per week and i wanted to
get
some help on this particular subject.
can u show me step by step how to calculate the total amount of hours
worked
and the total hours for the week?
i am quite new to the hour formula and i need some assistance , is there
anyone who can help me?
pls use the following eg. in your explanation
John Smith
time in - 9am
time out- 12:30pm* (*this is lunch break)
time in -1pm
time out -4:30 pm
best regards
sharmila

"Patrick" wrote:

I want to add hours and minutes in Excel but want the result to be
displayed
as hours and minutes. not in decimal form. In other words, if I have
Excel
add 17:30 +17:30+17:30+17:30 I want the total to come out to 70:00,
representing 70 hours and 0 minutes. I am increasing time in 15 minute
increments. I run into the expected problem when I get beyond 23:45 (23
hours
and 59) minutes. Then Excel, seeing this as time (mindnight) starts all
over
again and gives me 0:00. I do understand that Excel sees these type of
entries (17:30) as time and that is why it switches to 0:00 when it hits
24:00. I am just trying to find a way to tell it NOT to do that and to
just
keep increasing in the 15 minute increments I need to use, changing the
total
hours by 1 whenever the minutes reach :60.

Many thanks in advance for any suggestions!