Time and Date Duration Calculate duration with both date and time included. To present the difference between two times as a decimal number use this formula. INTC5 - B5 days TEXTC5 - B5h hrs m mins.
API Services for Developers.
INTC5 - B5 days TEXTC5 - B5h hrs m mins. INTC5 - B5 days TEXTC5 - B5h hrs m mins. In another cell use the DATEDIF formula with the ym parameter. In the Date Time Wizard dialog window switch to the Difference tab and do the following.