How to convert minutes to business days?

[GTZferg]

Hi I am trying to build a calculator in Excel 365 that will convert minutes spent per day doing a task at work everyday into how many total business days per year that is. I would like the number to come our as (Years) : (Months) : (Weeks) : (Days) : (Hours) : (Minutes). This would be based on a 40 hour work week and 250 business days per year. So basically I want to know if someone spends 15 mins everyday at work doing a task how much time is that per year?

[Pete_UK]

You need to define what you mean by a "month" - is it 4 weeks, or 30 days, or something else?

Pete

[GTZferg]

A business month would would be 20.8333333 days

[Pete_UK]

And how would you record 15 mins per day for an activity? Would it be as the number 15, or as 00:15 (i.e. in time format)?

Pete