• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Subtract time

Dear all,

I have the following Excel.

C5 marks the starttime, C7 the endtime and C6 the number of minutes of a break.

I would like to take the total amount of hours (C7-C5) and subtract the number of minutes (so in this example 7h and 10 min). But doing C7-C5-C6 does not work. Any thoughts on how I can get this working?

kr,
Marc
 

Attachments

  • uren-format-werkstudenten.xlsx
    11.9 KB · Views: 5
Yes .. 30 means 30 days as You have noticed.
Did You noticed?
I gave a sample - write eg 00:15 ( 15 minutes ) above.
Or
You should try to format Your 'break' column for minutes.

marcvanderpeet12

You seems to delete Your previous reply after I replied.
Did You get an idea - what to do?
 
Last edited:

pecoflyer

Yes, it will be.
It would be smoother to read all lines of replies before post a new posting.
As well as - after solution has gotten, there would be Solved post from OP.
 
Back
Top