EXCEL

[OSCAR]

HOW DO I GET CELLS TO EQUAVAL TIME? AS IN 2:00PM + 6:45PM = 4.75 HRS.

 

[Duane Hookom]

1st, this is a Microsoft Access news group, not Excel.
2nd, it is consider SHOUTING when you type in all caps.
3rd, I'm not sure why you would add two points in time and expect to get a
duration of time.

 

[OSCAR]

Read again. Thats not what I'm trying to do. Thanks and no thanks.
Everyone else has understood and helped.

 

[TC]

I would say your chances of getting any further help in this newsgroup
would be, er, let me see ... calculate ... calculate ... somewhat less
than zero.

TC

 

[OSCAR]

aCTUALLY i DID GET THE HELP i NEEDED. tHANKS. aND IF i COULD DELETE THIS
POST i WOULD. THANKS AGAIN.

 

[John Vinson]

Read again. Thats not what I'm trying to do. Thanks and no thanks.
Everyone else has understood and helped.

I think Duane read just fine.

The name of this newsgroup is microsoft.public.access.tablesdbdesign.
It's a newsgroup for people creating Tables in the database program
Microsoft Access. There are other newsgroups for Microsoft Excel, such
as microsoft.public.excel.general; if you scroll down the list of
newsgroups (subjects) on the left side of the webpage you'll find
them.

It is considered impolite - and it's certainly hard to read - when you
type in all caps.

Thirdly, adding 2:00 pm to 6:45pm would not make any sense. The
*differance* - subtracting them - is in fact 4.75 hours. I don't know
how to do this in Excel, but in Access you'ld use DateDiff("n",
[Starttime], [Endtime]) / 60 to calculate the difference in integer
minutes and then divide by 60 to get fractional hours.


John W. Vinson[MVP]