[mso] Re: Excel Dates
- From: "Renaud, Parker" <PRenaud@xxxxxxxxxxxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Tue, 10 Dec 2002 16:12:01 -0500
Stephen-
If you use 24 hour notation for your times, Excel will subtract times very
easily. Put each time in a different cell such as 8:00 or 15:00. Then, just
perform a standard subtraction and the result will show as 7:00.
Parker Renaud
IT Manager
Colliers Keenan Inc.
803-401-4264
prenaud@xxxxxxxxxxxxxxxxxx
-----Original Message-----
From: Stephen Doyle [mailto:steve@xxxxxxxxxxxxxxx]
Sent: Tuesday, December 10, 2002 4:00 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Dates
OOOOPs that should have read 8.00am-3.00pm=7hrs
Cheers
Stephen Doyle
steve@xxxxxxxxxxxxxxx
----- Original Message -----
From: "Stephen Doyle" <steve@xxxxxxxxxxxxxxx>
To: "Microsoft Office Freelist" <mso@xxxxxxxxxxxxx>
Sent: Wednesday, December 11, 2002 9:51 AM
Subject: [mso] Excel Dates
> Hi Gang,
>
> Is there a way of getting Excel to calculate hours from time periods. eg
8.00am-3.00pm = 8hrs.
>
> TIA
>
> Cheers
>
> Stephen Doyle
> steve@xxxxxxxxxxxxxxx
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.427 / Virus Database: 240 - Release Date: 6/12/2002
>
> *************************************************************
> 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
> *************************************************************
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.427 / Virus Database: 240 - Release Date: 6/12/2002
*************************************************************
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:
