Calculated Column: Calculate the difference between two times

You can calculate the difference between the time an item is created and modified via the following formulas:

=TEXT([Modified]-[Created],”h”) Displays the hours between the two times;

=TEXT([Modified]-[Created],”h:mm”) Displays the hours and minutes between the two times;

=TEXT([Modified]-[Created],”h:mm:ss”) Displays the hours, minutes and seconds between two times.

For the methods to work, hours must not exceed 24, and minutes and seconds must not exceed 60.

Leave a Reply

Your email address will not be published. Required fields are marked *