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 *************************************************************