Thanks:  0
Likes:  0

# Thread: Time Calculation and Conversion

1. Nope I didn't get that formula to work either. Are you using 12 hour time format or 24 when you did this formual?? Maybe that's why it's not working for me.

Thanks so far for everyone's responses!

2. On 2002-03-08 16:32, griggsbgsu wrote:
Nope I didn't get that formula to work either. Are you using 12 hour time format or 24 when you did this formual?? Maybe that's why it's not working for me.

Thanks so far for everyone's responses!
Formatting doesn't matter. All time values are stored as fractions of a day regardless of format.

3. Yeah! It worked! But there is still the little green triangle in the corner because it says the formula is inconsistent. Know how I get rid of that?

4. I got rid of it, you just ignore the error, easy enough! Thanks so much for the help! And I got answers so fast! You guys rock! I'll be back if I need help again. Thank you!

5. ## Subtracting minutes in hh:mm format, and set hours

I see how this works, and it's great, but now I have two additional problems. I want to subtract a lunch time (not always an hour) and calculate overtime. I want to be able to put my lunch in the hh:mm format - 0:45 for 45 minutes, which I think I've figured out (see below). I also want to calculate overtime by subtracting a blank 8 hours from my total hours cell. How could I accomplish this?

I have all cells in the hh:mm format

I have a1=time in
b1=lunch length
c1=time out
d1=total hours [ =SUM((C1-A1)-(B1)) ]
e1=overtime

6. Welcome to MrExcel.
Put this in E1
=MAX(D1-8,0)

FYI, in future you should post a question in a new topic and reference this topic in your question.

Best regards,

7. I have a question along the same line. If it is ok to post here, I will. If I need to start a new thread then let me know

8. The best is to post a new thread and reference this thread in it.

Best regards,

## User Tag List

#### Posting Permissions

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