# time calculation without lunch hour

1. ## time calculation without lunch hour

Hi

1) provide a formula that can minus out 12pm to 1pm lunch hour in column F?
2) provide a good website that explain times function in excel?

Thanks

2. ## Re: time calcuation without lunch hour

Hi,

you could subtract -1/24 (one hour)

=C1-B1-1/24

Hope it helps

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

3. ## Re: time calcuation without lunch hour

CANAPONE's solution works if the shift always includes the time from 12-1. Harrold, that's what your examples show but is that always the case? Your formulas seem to show that you have a good grasp on time calculations. Here is a page on dates and times from a very good Excel site.

4. ## Re: time calcuation without lunch hour

Hi Canapone,

i am doing payroll and there lots of O/T claims. If possible, i would like to find a formula that can automate deduct 12pm-1pm from the calculation. i prefer not to manually amend some of the formula where those time are involved. It resulted formula not consisitent.

Thanks

5. ## Re: time calcuation without lunch hour

Hi 6StringJazzer,

Harrold, that's what your examples show but is that always the case?
No, it is not.

Basically, everything is done manually. the workers fill in the OT form stating OT start & finish. Some of them cheated by include normal working hours, same OT to claim more than once, etc. The supervisors approve these OT without checking properly. So now, i need to use Excel to calculate the actual OT hours. and with a formula to calculate without lunch hour will make my work easier.

Thanks

6. ## Re: time calcuation without lunch hour

Hi,

example: the formula does not consider hours or minutes from 12 am to 1 pm

``Please Login or Register  to view this content.``
Regards

7. ## Re: time calculation without lunch hour

Hi Canapone,

I tried your formula and dont know whether i have put in the correct cell. Is it possible to upload a file for me?

Thanks

8. ## Re: time calculation without lunch hour

Hi,

after double-checking my previous attempt, I prefer

``Please Login or Register  to view this content.``
The formula cuts off period 12:00 am 1:00 pm

See the example attached

Let me know if you get unwanted results.

You'll get for sure better solutions.

Regards

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1