Dividing time with time or number

Hello,

I've made a work time sheet where I have the time when I came to work and when I left work formatted as h:mm. Then I have a column where I have the time in minutes I spent on breaks (h:mm as well). Then I calculate my total work time fir that day with an =End-Start-Break formula, which returns it in the same h:mm format.

After the day total comes a column with a +/- column, where I substract 7:15 (7 hours 15 minutes or 7,25 hours) from the day total to give me a number in h:mm of how much it went over or under the normal working hours. So if I start at 9:15, end at 16:50 and have a 00:15 break in between, I have a total of 7:20 which is +00:05 overtime.

For each week I have a week total which totals the +/- column. Below that is another total which calculates all-time total so I can keep track of how many days, hours or minutes I have overtime in total (it sums up last week's and this week's totals). Here comes the question part. Since it's in h:mm format, I get for example 08:08 which means that I have 1 workday and 53 minutes overtime. How can I convert the h:mm version to a version where I have the actual number of full 7:15 work days and then the remaining part? It can be separated to adjacent cells if needed, the only requirement would be that it says actual "days" / hours / minutes, not hours in decimal format.

I have Excel2010 that I've set to use the 1904 date system. I used to have the whole thing in decimal format but it was rather annoying to use so I decided to make a more readable version. But with decimals it was quite easy to just divide the total sum with 7,25.

I have an example file attached.

Hi
Try this formula. Change cell references to suit:

=IF(J32>A2,"1 day " & MINUTE(J32-A2) & "minutes")

Good luck.
Tony

Thank you all very much!