SharePoint List Days old calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-2002449%22%20slang%3D%22en-US%22%3ESharePoint%20List%20Days%20old%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2002449%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20SharePoint%20Days%20old%20calculation%20is%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3DIF(LEN(%5BDate%20reported%5D)%3D0%2C0%2CDATEDIF(%5BDate%20reported%5D%2CTODAY()%2C%22d%22))%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20formula%20would%20be%20used%20for%20Hours%20old%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJ%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2002449%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2002531%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20Days%20old%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2002531%22%20slang%3D%22en-US%22%3EHave%20you%20looked%20at%20the%20documentation%20for%20DATEDIFF%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2008786%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20Days%20old%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2008786%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702117%22%20target%3D%22_blank%22%3E%40BradD%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Brad%20I%20have%20looked%20but%20struggling%20to%20understand%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All,

 

The SharePoint Days old calculation is

 

=IF(LEN([Date reported])=0,0,DATEDIF([Date reported],TODAY(),"d"))

 

What formula would be used for Hours old?

 

J

2 Replies
Have you looked at the documentation for DATEDIFF?

@BradD 

 

Hi Brad I have looked but struggling to understand it.