Format codes display day numbers rather than count of days. Start date in A1, end date in B1 ... =TEXT(INT(B1-A1);"00")&" Days, "&TEXT(B1-A1;"HH:MM") ... returns a text value like "3 Days, 13:45" for display purposes. For further calculations you should refer to the original numbers A1 and B1.
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
