Calculate time with a break and total hours

A

Anita

I'm trying to calculate length of hours with a break included, but I'm not
sure it's calculating correctly. Here's what I have in military time:

C6=8:00
C7=12:30
C8=13:30
C9=17:25

The formula I have to calculate the total of those hours is:
=C9-C6-1/24+(C9>C6)

The break is usually 1 hour, but it can be less or more than 1 hour so I'd
like to change my formula if possible to allow for that variation.

I'm also trying to add the total hours together, but it's not displaying
right. My hours are:

8:25 + 8:15 + 8:15 + 8:25 + 8:00 = 6.72

I used the sum function, but I know all that adds up to more than 6.72. :)

TIA!
Anita
 
D

Dave

Hi,
Try this formula for the first question:
=C7-C6+C9-C8
Not sure about the second question
Regards - Dave.
 
D

Dave

Hi,
For your second question, try formatting the cells with:
[h]:mm (including the Total)
Regards - Dave.
 
F

Fred Smith

LeAnn,

If you want a solution to your problem, you need to do explain what "doesn't
work" means. No one can guess what's happening. You have to tell us. If it
gives the wrong result, tell us what result you got, and what you expected.

However, if you just want to be a victim ("poor me, this is an impossible
task"), ignore this post.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top