Excel schedule worksheet problem

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 formula
"=((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 me
-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 (lunch
hour).
- A formula that gives me the total hours worked by a group of people
for that day.

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

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

Thanks
KE


---
Message posted from http://www.ExcelForum.com/

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

--
Regards
Frank Kabel
Frankfurt, Germany


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 formula
"=((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 me
-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 (lunch
hour).
- A formula that gives me the total hours worked by a group of people
for that day.

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

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

Thanks
KE


---
Message posted from http://www.ExcelForum.com/

Try:

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

Regards

Trevor


"kaloseimi " wrote in message
...
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 formula
"=((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 me
-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 (lunch
hour).
- A formula that gives me the total hours worked by a group of people
for that day.

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

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

Thanks
KE


---
Message posted from http://www.ExcelForum.com/