Truncate Decimal Time to .0

[SDruley]

I have the time "00:08.6" formatted to "hh:mm.0".
What can I multiply, add, subtract or divide this time by to get "00:08.0"

[shg]

=floor(a1, "0:01")

[AlKey]

@shg

It shows zeros only.

Maybe with this

Please Login or Register  to view this content.

format Custom, mm:ss.0

Data Range

	A	B
1	00:08.6	00:08.0

[shg]

That's to the second, Al. Steve said the format was hh:mm.0, not mm:ss.0

[SDruley]

Time___________________AlKey____shg
00:08.6 112.698 112.718 00:08.0 00:00.0
00:09.1 112.694 112.718 00:09.0 00:00.0
00:09.9 112.694 112.717 00:09.0 00:00.0
00:10.9 112.694 112.716 00:10.0 00:00.0
00:12.4 112.691 112.716 00:12.0 00:00.0
00:13.9 112.689 112.716 00:13.0 00:00.0
00:14.1 112.69 112.716 00:14.0 00:00.0
00:14.6 112.691 112.715 00:14.0 00:00.0
00:15.6 112.692 112.715 00:15.0 00:00.0
00:17.1 112.693 112.715 00:17.0 00:00.0
00:17.9 112.694 112.715 00:17.0 00:00.0
00:18.1 112.694 112.714 00:18.0 00:00.0
I appreciate the feedback from both gurus. Thank you very much. It appears that the AlKey solution worked the best in this case.

[AlKey]

You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

[teylyn]

SDruley, Just for the record: 00:08.6 formatted with hh:mm.0 will display as 00:00.6, not as 00:08.6

So what was the format?