Back to articles
FormulasIntermediateTime and Date
2011-02-232 min read

A Woopra Chat About Excel

Functions in this article

Jump to the reference pages for the Excel functions used below.

Browse library

Woopra Desktop AppI 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)

Visitor #13357: 08:53:19. HI You: 08:53:28. Howdy

Visitor #13357: 08:54:22. I WANT TO CONVERT 01:05 = 65 MIN WHAT I DO 08:55:42. IN EXCEL You: 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.

Visitor #13357: 08:57:42. I NEED IN THIS FORMAT 08:57:46. 65 MIN You: 08:58:41. Change the formula in B1 to =A1*24*60 & " MIN"

Visitor #13357: 09:00:21. MY TIME FORMAT IN 01:01 AND IT SHOWS 60.9999999999999 MIN NOT 61 MIN You: 09:03:04. Try this =TEXT(A1*24*60,"#") & " MIN"

Visitor #13357: 09:04:38. THANKS ITS WORKING 09:04:44. THANKS A LOT You: 09:04:49. Glad to help.

Woopra window

The strange thing I just noticed is that some of my replies have periods at the end. In a chat session no less!

Enjoyed this guide?

Join our newsletter to get the latest Excel tips delivered to your inbox.

You can unsubscribe anytime. See our Privacy Policy.