[mso] Re: Converting Times in Excel hundredths of a minute

From: "Donald C. Smith" <DCSmith@xxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Date: Thu, 25 Sep 2003 19:43:53 -0400

Thanks, It works great.  And the opposite works for the conversion in the
opposite direction.

A1*24, At least that is what I came up with and seems to work, let me know
if I am wrong.

Thanks Again
Don


Subject: [mso] Re: Running office files over a remote network; Converting
Times in Excel hundredths of a minute :VSMail mx2
From: James LaBorde <jlaborde@xxxxxxxxx>
Date: Thu, 25 Sep 2003 15:14:26 -0700

Donald,

Question 2 is relatively easy.  Keep your data in one column, in the second
column change the format to time and enter the formula:

=A1/24

This is assuming that your original value is in A1 of course.  This will
give you the conversion.

If you want to put it into a macro or something just remember that in time,
1 represents one day.  So dividing by 24 gives your the # of hours.

James



*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

[mso] Re: Converting Times in Excel hundredths of a minute

Other related posts: