Search results

Thanks for your help on this namliam I have done what you said and left the time duration in decimal format. I have changed the format to custom ([h]:mm:ss) in the field setting for average time duration in my pivot table. It converts it from the decimal time duration to [h]:mm:ss format :)...

Hello all, I am new here and am hpoing someone can help. The problem I have is: I have a query, it contains a start date and a end date. I have tried various options to calculate the time difference in a hours and minutes less holidays and less weekend days. I am confident I have go...