Excel schedule worksheet problem

[kaloseimi]

Greetings:

Using XL2000 to modify file that creates work schedule.

- Cells formated for times.
- I enter 6 Am and 3 pm in two adjacent cells and the formul
"=((C10-INT(C10))*24)-((B10-INT(B10))*24)" gives me 9 hours.
- I need eight hours.
- If I enter "=((C10-INT(C10))*24)-((B10-INT(B10))*24-1)" it gives m
-1 for the value if I enter nothing, which would happen on a day off.
- Data entered is in time format but output must be in general
integer format.

I need:
- A formula / function that gives me the total hours worked -1 (lunc
hour).
- A formula that gives me the total hours worked by a group of peopl
for that day.

I have formula for total hours per week per employee and total hour
per week for everyone.

If there is a file that I can access that has examples, etc...pleas
point me to it.

Thanks
K

 

[Frank Kabel]

Hi
why not use
=(C10-B10)*24-1
if you only enter time values. or if you enter date/time values try
=(MOD(C10,1)-MOD(B10,1))*24-1

 

[Trevor Shuttleworth]

Try:

=((C10-INT(C10))*24)-((B10-INT(B10))*24)-1

Regards

Trevor