Hi

You have to know a little theory on this. 1 is a day in excel. Which makes
0.5 half a day, 12 hours, and 8:30 the same as 1/3. See
http://www.cpearson.com/excel/datetime.htm for reading and samples.

When you get used to it it's very simple from there.

HTH. Best wishes Harald

"Superslinky" skrev i
melding ...

Can anyone help me do this? D1-B1-C1=8.5 hours for the day. How do I
format the cells so that excel knows that 0.5 = 1/2 hour. As I have it
right now I get a return of something like this (#######). The example
below should make what I'm trying to do clear. Don't mind the dashes, I
put them in there to help represent the columns and rows. Any help would
be greatly appriciated.


-------A------------B--------C--------D--------E------------F

1-----Date--------Time in-- Lunch---Time out---Hours-- Hours to Date
2-----01/17/05----8:00-----0.5------17:00------8.5----8.5
3-----01/18/05----7:30-----0.5------17:00------9------17.5


--
Superslinky