Converting Time Valure to a Unit QTY Value

[Lee J]

I have a Time Duration field which is calculated by the usual Start/Stop times.

I then need this to be converted to a Unit value to be used as a qty.

Currently I copy the Time value into a dummy field, I then create a new calculation using a combination of TimeToText, Right() to remove Seconds and then Substitute() to convert the ascii character ":" to "."

and I finally get my qty ie. 5:35:45 becomes 5.35

Can someone please clarify if this is a good way of doing it?, or maybe offer a better option.

Cheers

[BobWeaver]

Much easier is to just treat your time duration directly as a number. It is numerically equal to the duration in seconds. If you want it in minutes, divide it by 60. If you want it in hours divide by 3600. You don't have to do any conversion. It's all automatic.

[Lee J]

Thanks Bob,

I did forget to say that I am also calculating the days elapsed in my final Time Duration calc, however with some minor changes it seems to be working fine.