Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Networking Days issue

Hi,

I have 2 timestamps and i need the time difference(in HH:MM format) between those 2 timestamps excluding Saturday,Sunday(NetworkingDays), how can i do this?

please find the attachment.

1 Reply
Gysbert_Wassenaar

Something like: interval(networkdays(StartDate,EndDate)+frac(EndDate)-frac(StartDate),'hh:mm')


talk is cheap, supply exceeds demand