Is it possible to convert a duration array to something else like a number or string?

When finding the difference between two datetime scalars the result is a duration array. And i need it to be a double or a string.

Answer 1

[Steven Lord]

If you convert the duration to a double, what should it represent? The number of years, days, hours, minutes, seconds, or milliseconds that duration represents? See the functions that have those names on the documentation page to which I linked.

[Edited to update broken link.]

[Bob Hay]

where is the link you refer to "See the functions that have those names on the documentation page to which I linked." the link retuns page not found I need the answer, how to convert duration back to datenum double. assume I'm using a 1x1 duration

[Steven Lord]

The link broke. I updated it to point to the page listing the functions you can use to create or manipulate a datetime or duration array. See the links to the years, days, hours, minutes, seconds, and milliseconds documentation pages on that page.

Answer 2

[Walter Roberson]

You can apply char() to a duration object. You can set the Format property of the duration object before using char()

Answer 3

[Mohammad Kifayath Chowdhury]

This could be useful,

Tx=datetime(T1)-datetime(T2);

Tx=hours(Tx); This will give the hours value as double.