I have attached my workbook to this post with comments and questions on the problems I am having. I have a couple questions on time calculations, which I can't seem to get right. Can someone please help me?!
JEP
I have attached my workbook to this post with comments and questions on the problems I am having. I have a couple questions on time calculations, which I can't seem to get right. Can someone please help me?!
JEP
First one
=IF(G5="","",IF(MOD(G5-G4,1)-Formulas!$B$2,MOD(F5-F4,1)-Formulas!B2,""))
Second one
format as [h]:mm
Thanks for your help!!
It helped with Tuesday through Friday but the Monday cells can't use the same formula because there is no day before it. Another thing is, what if there were no hours worked the day before.
The information you gave me about Comment 2 worked great, but only when I used your formula.
That was my error, I meant
=IF(G5="","",IF(MOD(G5-G4,1)-Formulas!$B$2,MOD(G5-G4,1)-Formulas!$B$2,""))
THANK YOU!!! That fixed it!!
Post Deleted
Last edited by scottylad2; 09-29-2011 at 01:56 PM.
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
Actually, ignore my last, this is better
=IF(OR(C4="",C5=""),"",MOD(C5-C4,1)-Formulas!$B$2) then your sum will work in H32
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks