I use the Woopra desktop app to view live visitors to this WordPress blog. Visitors will see a Woopra window lurking about when I’m logged into my (free) Woopra account. One option is to initiate a chat session with me.
My first chat happened the other day. The chat notice startled me, but I quickly recovered and was able to interact with a visitor.
(Bold and color are my additions for clarity)
08:54:22. I WANT TO CONVERT 01:05 = 65 MIN WHAT I DO
08:55:42. IN EXCEL
08:56:58. In cell A1 type 1:05, and in cell B1 enter the formula =A1*24*60 then change the cell format to General and you’ll see the 65.
08:57:42. I NEED IN THIS FORMAT
08:57:46. 65 MIN
08:58:41. Change the formula in B1 to =A1*24*60 & ” MIN”
09:00:21. MY TIME FORMAT IN 01:01 AND IT SHOWS 60.9999999999999 MIN
NOT 61 MIN
09:03:04. Try this =TEXT(A1*24*60,”#”) & ” MIN”
09:04:38. THANKS ITS WORKING
09:04:44. THANKS A LOT
09:04:49. Glad to help.
The strange thing I just noticed is that some of my replies have periods at the end. In a chat session no less!