[mso] Re: Calculating Elapsed time in Excel
- From: "Dianne Gronfors" <gronfors@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 30 Jun 2002 21:12:13 -0400
Hi Linda - thanks for the link to the file in SmartGroups. In my case, I
need to calculate elapsed time in decimals of an hour but sometimes, the
time in is on Friday night and the time out is on Saturday morning
(restaurant staff). An example would be:
In: 2215 (we use military time) Out 0315 (next day).
I tried the file instructions on a simple one of In 1640 Out 2215 but
didn't get an answer, only ### which maximizing the column didn't correct.
What am I doing wrong? Dianne
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of Linda Johnson
Sent: June 30, 2002 8:24 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Calculating Elapsed time in Excel
Also...there's a good article on time formats in Excel in our
SmartGroups file section. It's in the Excel folder and it's called
Tip_Excel_Time_Calculations.doc
It explains a lot and I think anyone who wants to learn more about time
in Excel, should read it.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Dianne Gronfors
Sent: Sunday, June 30, 2002 7:32 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Calculating Elapsed time in Excel
Gary - are you looking for your results to be shown in decimals of an
hour?
I have a set-up to do just that but it wasn't easy. Involves a large
lookup
table on a separate sheet but if you're interested, I could send it to
you
privately for you to look at. Dianne
*************************************************************
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?Subject=unsubscribe
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
*************************************************************
*************************************************************
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?Subject=unsubscribe
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
*************************************************************
Other related posts:
