Convert seconds to minutes in Log Analytics

%3CLINGO-SUB%20id%3D%22lingo-sub-1556795%22%20slang%3D%22en-US%22%3EConvert%20seconds%20to%20minutes%20in%20Log%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556795%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20run%20a%20Query%20in%20LogAnlytics%20to%20Query%20(ASR)%20RPO.%20KQL%20query%20has%20option%20only%20to%20display%20in%20seconds%20not%20minutes%2C%26nbsp%3B%3C%2FP%3E%3CP%3ESyntax%20is%20rpoInSeconds_d%26nbsp%3B%20%26nbsp%3B%3B%20any%20suggestions%20how%20to%20convert%20this%20into%20minutes%2C%20please%3F%20thanks!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1556795%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1572932%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20seconds%20to%20minutes%20in%20Log%20Analytics%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572932%22%20slang%3D%22en-US%22%3E%3CP%3Eyou%20can%20convert%20like%20this%3A%3C%2FP%3E%0A%3CDIV%3E%0A%3CDIV%3E%3CSPAN%3Evalue_in_minutes%20%3D%20value_in_seconds%2F%3C%2FSPAN%3E%3CSPAN%3E60%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

Trying to run a Query in LogAnlytics to Query (ASR) RPO. KQL query has option only to display in seconds not minutes, 

Syntax is rpoInSeconds_d   ; any suggestions how to convert this into minutes, please? thanks! 

1 Reply

you can convert like this:

value_in_minutes = value_in_seconds/60