Upto and Including 40 Hours into one column and the excess into another

[nathanB]

Hi all,

I have a customer who wants a report writing displaying time worked throughout the week. She wants 2 columns where it will display the totals for the week. In one column, she wants to display up to and including 40 hours worked, and in another display the excess. Example in the spreadsheet as well as below.

Total Time Worked for the week | Hours Upto 40 | Hours + 40
48:52 | 40:00 | 08:52
38:58 | 38:58 | 00:00

So it needs to reference the first column (total time) and then display them into the other columns.

Thanks for any assistance


Time Worked.xlsx

[Pepe Le Mokko]

Does the attached help ? Copy of Time Worked.xlsx

[nathanB]

That works perfectly, thank you Pepe. +1 rep

[Pepe Le Mokko]

You're welcome - Don't forget to indicate your thread as solved