Calculate minutes/seconds between two date fields

[abhilash.kumar.niit]

Hi i want to calculate minutes and seconds between two dates but want to exclude weekends. is there any formula function available for the same??

[esforim]

I dont think so, you have to mix it with this formula:

https://docs.espocrm.com/administration/formula/datetime/#datetimedayofweek

By doing a if sunday or saturday then -minus or skip the calculation

[yuri]

https://docs.espocrm.com/user-guide/working-time-calendar/#formula-functions

ext\workingTime\getSummedWorkingHours returns hours in float. Multiplying it by 60 will give the value in minutes.