Formula:
=TEXT(A70-A69, "h:mm:ss")
Other samples,
Calculate hours between two times:
=TEXT(B2-A2, "h")
Return hours and minutes between 2 times:
=TEXT(B2-A2, "h:mm")
Return hours, minutes and seconds between 2 times:
=TEXT(B2-A2, "h:mm:ss")
Subscribe to:
Post Comments (Atom)
Snowflake - Notes
WPRKSPACES - In September 2025, Snowflake introduced Workspaces, which combines the functionality of Worksheets, Notebooks, File Manager, Q...
-
MD5 (Message Digest Function) is a hash function in Informatica which is used to evaluate data integrity. The MD5 function uses Message-Dig...
-
Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
-
Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
No comments:
Post a Comment