T
Terry Pinnell
Could someone help me derive a formula that will turn a column of
seconds and decimals into hours, mins, secs, decimals please. For
example:
Original New
-------- ---------
92.16 00:01:32.16
3987.65 01:06:27.65
I can get there with several columns, and I suppose I could manipulate
these and get them into a single column, but I'm sure there must be a
more elegant solution?
seconds and decimals into hours, mins, secs, decimals please. For
example:
Original New
-------- ---------
92.16 00:01:32.16
3987.65 01:06:27.65
I can get there with several columns, and I suppose I could manipulate
these and get them into a single column, but I'm sure there must be a
more elegant solution?