marcvanderpeet12
Member
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
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