Hi, I am trying to add the hours scheduled to an employee, I am having trouble with the formula to calculate the amount of hours scheduled for the week.
For example: Monday "clock in" 10am(cell-C10), and Monday "clock out" at 3pm (cell-D10), and so on through Sunday. Would like to know how to compute the formula to total the hours worked for the week. If anyone could lend some advice it would be appreciated. Thank you.
It's not clear if shifts cross midnight or not - nor if the "time" values are real time values or text strings - ie what does =ISNUMBER(C10) return ?
If it returns TRUE then perhaps, to be safe, you could try:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Re: Trying to total the hours scheduled for an employee schedule
Hi
Do u mean like this???
Edit
Seems I late ....
Last edited by contaminated; 01-06-2010 at 04:29 AM.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Not quite it this attached is an example of the format I am trying to use.
In which case, earlier version adapted:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks