If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Excel schedule worksheet problem
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/ |
#3
|
|||
|
|||
Excel schedule worksheet problem
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/ |
Thread Tools | |
Display Modes | |
|
|