OT: Time Function in Excel Part II

Yahoo Archive
1
You can get the minute part with the function: =MINUTE(4.1/24) where you divide the decimal time by 24.
So you might have =MINUTE(B1 / 24) where B1 is a cell with a decimal time. You can get Hour easy enough with an Integer function on the decimal cell. Anyway, some places to start.
-Todd C.

-----Original Message-----
From: Juliet Martin [mailto:jmartin@...]
Sent: Wednesday, June 25, 2003 10:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Time Function in Excel Part II


Upon further investigation the employee wants me to be able to convert
.25 to 15 minutes. 4.10 to 4 hours and 6 minutes. Quite a bit more
complicated that I first thought.

Any ideas?

Juliet


Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1564416/R=0/SIG=11ti81skc/*http://www.netflix.com/Default?mqso=60164797&partid=3170658>
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1564416/rand=970536086>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Upon further investigation the employee wants me to be able to convert
.25 to 15 minutes. 4.10 to 4 hours and 6 minutes. Quite a bit more
complicated that I first thought.

Any ideas?

Juliet