OT: Time Function in Excel Part II - SOLVED

Yahoo Archive
1
Thanks. This did the trick. I appreciate your help.

-----Original Message-----
From: Juliet Martin
Sent: Thursday, June 26, 2003 8:06 AM
To: Juliet Martin
Subject: Fwd: RE: [Vantage] OT: Time Function in Excel Part II


--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
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@r...]
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